Docs  /  App  /  Excel Report Builder  /  Edit Evaluations  /  Data Sheets

 Date Filter Variables

2026/04/03 • 3 min. to read

In this topic

• A variable can be composed of the following IDs

It is possible to specify [Variables] in date filters that will be calculated and replaced based on the Evaluation Date when the evaluation executed. Basically, the variables are date formulas. However, the English date formulas are always used, e.g.: D (Day). The advantage over date formulas is that several date values (e.g. a date interval) can be specified combined in one filter. As Evaluation Date the Work Date is suggested. The suggested date can be additionally modified via the Evaluation Date Formula of the evaluation. Date Filter Variables can be used, for example, to set up evaluations where the date filter is automatically set to the current month when the evaluation is executed. A variable must begin with [ and end with ].

A variable can be composed of the following IDs:

• D Day
• WD Weekday
• W Week
• M Month
• Q Quarter
• Y Year
• C meaning 'current' and can be specified as a prefix to an ID

A list of date filter examples can be opened via the lookup of the date filter field.