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

Hi @Frank and everyone,

Good news, this is now possible :slightly_smiling_face:


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!