ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
This predefined function is used to calculate an eight-position date by adding a number of days to a beginning date.
With this predefined function, the date given as a parameter is checked. If it is not valid, the function is not run and the result field is reset to zero.
Syntax
Result = &CALCULATE_DATE8(Date format;Beginning date;Number of days)
Parameters
|
Description |
Contents |
Controls |
Result |
Eight-position numeric variable. |
Date calculated. |
|
Date format |
Three-position alphanumeric variable or constant. |
Format for the date set as a parameter Possible values: DMY Day/Month/Year DYM Day/Year/Month MDY Month/Day/Year MYD Month/Year/Day YMD Year/Month/Day YDM Year/Day/Month |
Mandatory parameter. |
Beginning date |
Eight-position numeric variable or constant. |
Beginning date to which the number of days set as a parameter is added. |
Mandatory parameter. |
Number of days |
Seven-position numeric variable or constant. |
Number of days to be added to the beginning date. |
Mandatory parameter. |
Note: If this parameter Number of days is negative, the number of days specified is deducted from the beginning date.
Example
ORDER_DATE = 20001231
NUMBER = 20
DEADLINE = &CALCULATE_DATE8('YMD';ORDER_DATE;NUMBER)
*
* The deadline date is 20010120
*
FORMAT = 'DMY'
END_CONTRACT = 06012001
NUMBER = -366
*
ORIGIN_DATE = &CALCULATE_DATE8(FORMAT;END_CONTRACT;NUMBER)
*
* The origin date is 06012000
List of predefined functions by topic