Docs / NCCA Cost Accounting / Evaluations / Edit Evaluations
Date Filter IDs
2023/09/20 • 3 min. to read
For
date filters, IDs (placeholders) can be specified in square brackets
[ ] that will be calculated and replaced based on the
Date Filter Calculation Date when the evaluation is executed.
Basically, the IDs 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.
The suggested date can be additionally modified via the
Date Filter Calculation Date Formula of the evaluation.
Date Filter IDs 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.
The following IDs are available:
- D Day
- WD Weekday
- W Week
- M Month
- Q Quarter
- Y Year
- C meaning 'current' and can be specified as a prefix of an ID
A list of Date Filter ID examples can be opened via the lookup of the date filter field.
