ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
This predefined function is used to calculate the day number for a date compared with the year 1.
With this predefined function, the date set 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 = &NUMBER_DATE(Date format;Date)
Parameters
|
Description |
Contents |
Controls |
Result |
Seven-position numeric variable. |
Date's absolute number as from the year 1. |
|
Date format |
Three-position alphanumeric constant or variable. |
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. |
Date |
Eight-position numeric constant or variable. |
Date to be processed. |
Mandatory parameter. |
Example
FORMAT = 'YMD'
DATE = 20020214
NUMBER_DATE = &NUMBER_DATE(FORMAT;DATE)
*
* NUMBER_DATE is equal to: 731276
List of predefined functions by topic