Rolling Dates - Dynamic Date Ranges

[kaush23]

I'm trying to build a report that only tracks revenue if the contract end date is before today. However, as today is a rolling number, when using filerts, I am not sure if I selecting "today" on the calendar, will result in  the date automatically rolling forward in the coming days. Is there a way to set rolling dates in filters? 

[karstenkoehler · Accepted solution]

Hi @kaush23,

I'd recommed using the "is last" date property filter option. This is always referring to the previous time range, excluding today:

Best regards!