Framework:FKT DateAdd

Function

Is used for the time offset. It is possible to add day/month/year to a date.

FKT_DateAdd(, <number of the invervals to be added >,<date value>)

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