Relative Date Variables

Chartio offers built-in date variables that can be used across the application. They each resolve to a single date string, so you can use them anywhere you would otherwise enter a date value. For example, you can:

  • set default dates for dashboard date filters, such as a Calendar filter or a Date Slider
  • use in custom formulas in the Data Pipeline
  • use in SQL Mode
  • use in Interactive Mode filters

Relative date variables follow the Time Zone your dashboard uses.

View examples

Available Variables

  • {TODAY}
  • {CURRENT_ISO_WEEK.START} and {CURRENT_ISO_WEEK.END}
  • {CURRENT_QUARTER.START} and {CURRENT_QUARTER.END}
  • {CURRENT_MONTH.START} and {CURRENT_MONTH.END}
  • {CURRENT_CALENDAR_YEAR.START} and {CURRENT_CALENDAR_YEAR.END}