Relative date variables
Analytics is now Insights
All of the Analytics capabilities of the app remain unchanged. You can continue using your existing dashboards, charts, and smart links alongside the new Rovo-powered features. These features combine work and data context to provide reliable answers, create a shared understanding of data, and build dashboards that your team can depend on.
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?