Smart Dates in Reports

Support for Data tags is available to be added to column filters within reports. With the use of the tags a user can create a report with a dynamic condition that will update based on the date that the report is run.

Using the ${today} tag will result in a report that always contains data from the current date regardless of when it was run. The date tags complement the existing selectors that are built into some reports, thus the date resolved by the tag must be within any range as specified by any report date selectors.

The date tags are listed below:

  • ${today}
  • ${yesterday}
  • ${tomorrow}
  • ${lastweek}
  • ${lastmonth}
  • ${last year}
  • ${nextweek}
  • ${nextmonth}
  • ${nextyear}
  • ${currentweek}
  • ${currentmonth}
  • ${currentyear}

Each tag will resolve to the first date in the period defined by that tag. For example, ${nextweek} will resolve to the date of the first day of the next week as defined in the company configuration. The filter is applied after all other data restrictions are applied.