|Docs
  AppSource ☰ Contents
  Support|  Feedback|  Print|  Share

Date Filter Parameters


2022/01/24
For date filters, parameters can be specified in square brackets [ ], which will be converted or calculated when the evaluation is executed. Basically, the parameters are date formulas. However, the English parameters 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. The parameters are calculated based on the Work Date. In evaluations, the calculation can additionally be controlled via the Date Filter Calc. Formula field. Date filter parameters 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 parameters 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 a parameter
A list of date filter parameter examples can be opened via the lookup of the date filter field.

Examples

The following table shows some examples of parameter combinations and their results when the Work Date or the Date Filter Calc. Date is set to 06/30/2020.
ExampleResultComment
[CD]06/30/20Date Filter Calc. Date
..[CD]..06/30/20Until Date Filter Calc. Date
01/01/20..[CD]01/01/20..06/30/2001/01/20 until Date Filter Calc. Date
..[-CM-1D]..05/31/20Until the end of last month (based on the Date Filter Calc. Date)
   
[-CM]..[CM]06/01/20..06/30/20Current Month
[-CM-1M]..[-CM-1D]05/01/20..05/31/20Last Month
[-CM-2M]..[-CM-1M-1D]04/01/20..04/30/202 months ago
[-CM-3M]..[-CM-2M-1D]03/01/20..03/31/203 months ago
[-CY]..[-CY+1M-1D]01/01/20..01/31/20January of the current year
[-CY+1M]..[-CY+2M-1D]02/01/20..02/29/20February of the current year
   
[-CY]..[CY]01/01/20..12/31/20Current Year
[-CY-1Y]..[CY-1Y]01/01/19..12/31/19Last Year
[-CY-2Y]..[CY-2Y]01/01/18..12/31/182 years ago
[-CY-2Y]..[CY]01/01/18..12/31/20The last 3 years
   
[-CQ]..[CQ] 04/01/20..06/30/20Current Quarter
[-CQ-1Q]..[-CQ-1D]01/01/20..03/31/20Last Quarter
[-CQ-2Q]..[-CQ-1Q-1D]10/01/19..12/31/192 quarters ago
[-CY]..[-CY+1Q-1D]01/01/20..03/31/20The first quarter of the current year
[-CY+1Q]..[-CY+2Q-1D]04/01/20..06/30/20The second quarter of the current year
[-CY+2Q]..[-CY+3Q-1D]07/01/20..09/30/20The third quarter of the current year
[-CY+3Q]..[CY]10/01/20..12/31/20The fourth quarter of the current year
☰ Contents
Next Topic: Sachkonto Kostenartzuordnung übersteuern
  Support|  Feedback|  Print|  Share
DE|EN Imprint
<>