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? 

[Bakertc]

Currently, when you click "today" on a calendar control, it hard codes the date to today's date.  It does not float when the calendar advances to tomorrow (like the excel function today()), and that would be an extremely useful feature to extend the very limited relative rolling date filter capabilities of Hubspot.

[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!