Get_Date
V_String
20
DateTimeFormat(DateTimeAdd(DateTimeNow(),-5,"days"),"%d.%m.%Y")
!IsEmpty(Get_Date)
NULL()
Scenario 1:
* Generate Date from 5 days ago
* Format Date as dd.mm.yyy
CALC_DATE
Date
10
DateTimeFirstOfMonth()
CALC_DATE>=[Start_Date]
DateTimeAdd([CALC_DATE],-1,"months")
2018-01-20
Scenario 2:
* Generate rows containing first of month, going back to a point in time in the data
CALC_DATE
Date
10
IF [End_Date]<[Trigger_date] THEN
DateTimeFormat(DateTimeAdd([End_Date],-1,"month"),"%Y-%m-01")
ELSE
DateTimeFormat([End_Date],"%Y-%m-01")
ENDIF
CALC_DATE>=[Start_Date]
DateTimeAdd([CALC_DATE],-1,"months")
1
2018-01-20
2018-12-10
2018-12-05
2
2019-04-10
2019-07-03
2019-07-05
Scenario 2:
* Generate rows containing first of month, between 2 given dates
* If the end date is less than the trigger date, use previous month
Horizontal
Tool_Of_Day_GenerateRows