Framework:FKT DateAdd: Difference between revisions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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: | 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== | ||
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”. | ||
| Line 41: | Line 40: | ||
<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 | ||
| Line 47: | Line 46: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions|DateAdd]] | |||
[[Category:Functions_-_server-side|DateAdd]] | [[Category:Functions_-_server-side|DateAdd]] | ||
[[de:Framework:FKT DateAdd]] | [[de:Framework:FKT DateAdd]] | ||
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
