Question

How to get a date filter from a static custom date to today?

  • 21 September 2022
  • 1 reply
  • 18 views

For a date filter I want keep the default date range from a custom date till current date.

Example : 1/1/2022 - Today

How to get this?


1 reply

Userlevel 7
Badge +1

You can use the filter option “is on or after” this way you only specify the start date but the end date has no limits. However, if you happen to have some future data like forecasting then that’s when we hit a roadblock. 

 

None of the advanced patterns allow us to use from {time} to {interval}/ now

 

It’s recomended to basically use two filters. For example:

 

Created Date: after 2022-01-01

Created Time: before tomorrow

Reply