Ask a Question
Back to All

How can I ignore values from dates earlier than today

I have a fixed payment arrangement with a customer and I'm trying to model the revenue (and cash flow) from that agreement.

March '22 amount: $10k
April '22 amount: $12k
May '22 amount: $18k
June '22 amount: $15k
July '22 amount: $16k

I have this setup as a list (=[10000,12000,18000,15000,16000,0]) over the interval March-July 2022. But since it is currently May, I only want to transmit the amounts after May 2022 to my checking account pool. Is there a way to Gate values based on a specific date (today)?