• Products
  • Documentation
  • Resources

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

Additional Help