It is possible to specify [Variables] in date filters that will be calculated and replaced based on the Date Filter Calculation Date when 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 Date Filter Calculation Date the Work Date is suggested.
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.
Examples
The following table shows some examples of Date Filter Variable combinations and their results when the Work Date or the Date Filter Calc. Date is set to 06/30/2020.
Example
Result
Comment
[CD]
06/30/20
Date Filter Calc. Date
..[CD]
..06/30/20
Until Date Filter Calc. Date
01/01/20..[CD]
01/01/20..06/30/20
01/01/20 until Date Filter Calc. Date
..[-CM-1D]
..05/31/20
Until the end of last month (based on the Date Filter Calc. Date)
Date Filter Variables
