DateAdd({Interval}, {Number}, {Date})
How can we define the number for add the Day,Weeks,Months and Year in the "Interval".. It defined as number
I am aware Like YYYY, MM, DD supports in DB and it's a varchar,
I struggled with this originally too.
The time interval is defined as such: (this can be found with F1 Help in the Calculation stage)
Interval DateAdd DateDiff
0 Year Year
1 Week Week of year (Calendar week)
2 (n/a) Weekday (Full 7 day week)
3 (n/a) Second
4 Quarter Quarter
5 Month Month
6 (n/a) Minute
7 (n/a) Hour
8 (n/a) Day of year
9 (n/a) Day
