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

[VHegde]

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?

[Dawid · Accepted solution]

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