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

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