Filter using relative date values ("TODAY" etc.)

[Frank]

Hi there, we really need to run filters on dates using relative terms like "today", "yesterday" etc. -- Salesforce has this ability and it's extrememly useful: https://help.salesforce.com/articleView?id=custom_dates.htm

Currently, if we want to run a List around our customers who expire at some point in the future, we have to go in and change the "after date" fitler each time to update the current date. (The rolling dates filter doesn't work in this case, because the dates we're looking for are in the future and not the past.)

Hopefully this is easy to do, thanks!

[Frank]

Hey everyone, in case you missed the update, we have some exciting news!!

Dynamic rolling dates are now available in Lists and Workflows

What is it?

We've improved the date range filtering experience in Lists. These dynamic filters update based on the date range you provide. For example, you could set a date range to be "this month," which means your list will always update to show records based on "this month's" data.

How does it work?

• Click to add your date/date-time property.
• You'll see a list of operators, choose the "is" operator,
• You can now access these new dynamic date range filter options and select the one you want to use
  
  

[Frank]

Hey HubSpot community - 

We know date filters can be a pain point for many of our users. We are currently reworking some of the "wiring" on our filters system which will set us up to be able to add consistency to our filters. Part of that will be introducing relative date filters where they are not currently available. 

Thanks

[VagaeNatus]

The Hubspot PM has reached out to me today to get on a call to discuss this idea, that's now 8 years old. What a joke. I told them to research the platform we have moved to since then. No time for a company that is this slow.

[Assoc-Sacto]

Please add this feature!

[karstenkoehler]

Hi @Frank and everyone,

Good news, this is now possible 🙂

---

Dynamic Dates in Lists and Workflows

• Last updated: May 5, 2025

What is it?

We've improved the date range filtering experience in Lists. These dynamic filters update based on the date range you provide.

For example, you could set a date range to be "this month," which means your list will always update to show records based on "this month's" data.

Why does it matter?

You can now choose the following date range filters for your Lists:

• Today
• Tomorrow
• Yesterday
• This week
• This week so far
• Last week
• Next week
• This month
• This month so far
• Last month
• Next month
• This quarter
• This quarter so far
• Last quarter
• Next quarter
• This year
• This year so far
• Last year
• Next year
• Last 7 days
• Last 14 days
• Last 30 days
• Last 60 days
• Last 90 days
• Last 180 days
• Last 365 days

How does it work?

• Click to add your date/date-time property.
• You'll see a list of operators, choose the "is" operator,
• You can now access these new dynamic date range filter options and select the one you want to use

Who gets it?

All hubs and tiers

---

Best regards!

[Crystal_Hopper]

We just ran into an issue where we need to trigger a Workflow on something that happened "yesterday." Less than 1 day ago isn't precise enough. 

@karstenkoehler can you provide a link to the article where that info is found. My searches are not finding it. Is it only for filters, and not triggers?

[karstenkoehler]

@Crystal_Hopper yesterday would be less than 1 days ago AND more than 0 days ago, as the previous midnight is used for reference.

[MiDesai]

Hey everyone, in case you missed the update, we have some exciting news!!

Dynamic rolling dates are now available in Lists and Workflows

What is it?

We've improved the date range filtering experience in Lists. These dynamic filters update based on the date range you provide. For example, you could set a date range to be "this month," which means your list will always update to show records based on "this month's" data.

How does it work?

• Click to add your date/date-time property.
• You'll see a list of operators, choose the "is" operator,
• You can now access these new dynamic date range filter options and select the one you want to use