Framework:FKT DateAdd: Difference between revisions
No edit summary |
No edit summary |
||
| Line 21: | Line 21: | ||
|} | |} | ||
Time interval: | Time interval: <br> | ||
Number of the intervals to be added: e. g. +1, -10 | Number of the intervals to be added: e. g. +1, -10<br> | ||
Date value: DD.MM.YYYY or “date” data type column | Date value: DD.MM.YYYY or “date” data type column <br> | ||
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”. | 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”.<br> | ||
Example b01_DateAdd: | Example b01_DateAdd:<br> | ||
Table: bsp_tbl_time functions | Table: bsp_tbl_time functions<br> | ||
Source column: date = 01.04.2005 | Source column: date = 01.04.2005 | ||
Syntax: b01_DateAdd: <span {{CoPFormel}}>FKT_DateAdd(M,+1,[bsp_tbl_time functions.date])</span> | Syntax: b01_DateAdd: <span {{CoPFormel}}>FKT_DateAdd(M,+1,[bsp_tbl_time functions.date])</span><br> | ||
Results column: reference date = 01.05.2005 | Results column: reference date = 01.05.2005<br> | ||
==Result== | ==Result== | ||
| Line 41: | Line 41: | ||
<u>Source :</u> date = 01.04.2005 | <u>Source :</u> date = 01.04.2005 | ||
<u>Syntax:</u> b01_DateAdd: FKT_DateAdd(M,+1,[bsp_tbl_time functions.date] ) | <u>Syntax:</u> b01_DateAdd: <span {{CoPFormel}}>FKT_DateAdd(M,+1,[bsp_tbl_time functions.date])</span> | ||
<u>Results column:</u> reference date = 01.05.2005 | <u>Results column:</u> reference date = 01.05.2005 | ||
Revision as of 16:15, 6 March 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 |
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
