ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
This predefined function is used to calculate a date from its absolute number compared with the year 1.
Syntax
Result = &DATE_NUMBER(Date format;Absolute number)
Parameters
|
Description |
Contents |
Controls |
Result |
Eight-position numeric variable. |
Date calculated from the specified day number set as a parameter. |
|
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. |
Absolute number |
Seven-position numeric variable or constant. |
Number for which |
Mandatory parameter. |
Note: The absolute number set as a parameter must not exceed 3652440, which corresponds to the date 31 12 9999.
Example
FORMAT = 'DMY'
NUMBER = 727944
DATE = &DATE_NUMBER(FORMAT;NUMBER)
*
* The DATE is equal to: 14022002
List of predefined functions by topic