Framework:FKT DateAdd: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
<span {{CoPFormel}}>FKT_DateAdd(<time interval>, <number of the invervals to be added >,<date value>)</span> | <span {{CoPFormel}}>FKT_DateAdd(<time interval>, <number of the invervals to be added >,<date value>)</span> | ||
{|class="wikitable" width="80%" | {|class="wikitable" width="80%" | ||
| Line 20: | Line 19: | ||
|DD.MM.YYYY or “date” data type column | |DD.MM.YYYY or “date” data type column | ||
|} | |} | ||
This function belongs to [[:Category:Functions_-_server-side|server-side functions]]. | |||
Time interval: <br> | Time interval: <br> | ||
| Line 32: | Line 32: | ||
==Result== | ==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”. | 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”. | ||
Latest revision as of 08:33, 24 May 2012
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
