topic Re: Rolling Dates - Dynamic Date Ranges in 💬 RevOps Discussions

Rolling Dates - Dynamic Date Ranges

kaush23 — Fri, 25 Mar 2022 21:51:13 GMT

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?

Re: Rolling Dates - Dynamic Date Ranges

karstenkoehler — Sat, 26 Mar 2022 06:32:27 GMT

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!

Re: Rolling Dates - Dynamic Date Ranges

Bakertc — Tue, 04 Mar 2025 13:35:32 GMT

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.