# Rolling Dates - Dynamic Date Ranges

**URL:** <https://community.hubspot.com/t/rolling-dates-dynamic-date-ranges/53882>\
**Category:** 💬 RevOps Discussions\
**Tags:** filters, reporting\
**Created:** [March 25, 2022, 9:51pm UTC](https://community.hubspot.com/t/rolling-dates-dynamic-date-ranges/53882 "2022-03-25T21:51:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kaush23](https://avatars.discourse-cdn.com/v4/letter/k/c6cbf5/32.png) [@kaush23](https://community.hubspot.com/u/kaush23)\
**Post date:** [March 25, 2022, 9:51pm UTC](https://community.hubspot.com/t/rolling-dates-dynamic-date-ranges/53882/1 "2022-03-25T21:51:13Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 26, 2022, 6:32am UTC](https://community.hubspot.com/t/rolling-dates-dynamic-date-ranges/53882/2 "2022-03-26T06:32:27Z")

</div>

Hi @kaush23,

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

 ![karstenkoehler_0-1648276339965.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/5/753cad32f5c3f4005906317f680fefd7cf4439a2.png)

Best regards!

---

<div class="post-metadata">

**Author:** ![Bakertc](https://avatars.discourse-cdn.com/v4/letter/b/b9bd4f/32.png) [@Bakertc](https://community.hubspot.com/u/Bakertc)\
**Post date:** [March 4, 2025, 1:35pm UTC](https://community.hubspot.com/t/rolling-dates-dynamic-date-ranges/53882/3 "2025-03-04T13:35:32Z")

</div>

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.