Relative date variables
Use relative date variables to dynamically update date values in your dashboards and charts. Learn more about variables.
Apply date and time functions to relative date variables to customize the returned date to fit your needs. Learn more about date and time functions.
The following relative date variables are available:
Today
Variable: {TODAY}
Returns today’s date
Start and end dates of the current ISO week
Variables: {CURRENT_ISO_WEEK.START} and {CURRENT_ISO_WEEK.END}
Returns the start and end dates, respectively, of the current ISO week
Keep in mind that ISO weeks start on Mondays.
Start and end dates of the current month
Variables: {CURRENT_MONTH.START} and {CURRENT_MONTH.END}
Returns the start and end dates, respectively, of the current month
Start and end dates of the current quarter
Variables: {CURRENT_QUARTER.START} and {CURRENT_QUARTER.END}
Returns the start and end dates, respectively, of the current quarter
Start and end dates of the current ISO year
Variables: {CURRENT_ISO_YEAR.START} and {CURRENT_ISO_YEAR.END}
Returns the start and end dates, respectively, of the current ISO year
Start and end dates of the current calendar year
Variables: {CURRENT_CALENDAR_YEAR.START} and {CURRENT_CALENDAR_YEAR.END}
Returns the start and end dates, respectively, of the current calendar year
Was this helpful?