Framework:FKT DateAdd
Function
Is used for the time offset. It is possible to add day/month/year to a date.
FKT_DateAdd(
| Parameter | Description |
| time interval | Y (year), D (day), M (month), Q (quarter) |
| number of the invervals to be added | z.B. +1, -10 |
| date value | DD.MM.YYYY or “date” data type column |
This function belongs to server-side functions.
Time interval:
Number of the intervals to be added: e. g. +1, -10
Date value: DD.MM.YYYY or “date” data type column
Result A “date” data type value is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “date value”.
Example b01_DateAdd:
Table: bsp_tbl_time functions
Source column: date = 01.04.2005
Syntax: b01_DateAdd: FKT_DateAdd(M,+1,[bsp_tbl_time functions.date])
Results column: reference date = 01.05.2005
Result
A “date” data type value is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “date value”.
Example b01_DateAdd
Table: bsp_tbl_time functions
Source : date = 01.04.2005
Syntax: b01_DateAdd: FKT_DateAdd(M,+1,[bsp_tbl_time functions.date])
Results column: reference date = 01.05.2005
