For static dates, we have a Date Picker form component, but sometimes you will find yourself needing to reference a dynamic date.

For example, you want a dashboard to display all records from the past three days, but you want that to update automatically every day.

With Relative Time Variables, this is very simple:

For Today's date, simply enter {{ today }}

For the current time, simply enter {{ current_time }}

For a custom date of X days ago, use the following syntax: {{ days_ago_X }} where X is the number of days you need.

For example {{ days_ago_14 }} would give you a date of 14 days ago.

Using this in the value field of a Date filter produces a relative date filter that will update daily to always show the past X days.

Easy, right?

If you have any questions, please contact us via live chat or [email protected]

Did this answer your question?