To return a date from three given numbers: year, month and day
Ymdtod(Numeric-expression1, Numeric-expression2, Numeric-expression3)
Type Returned:
Date
Where:
Numeric-expression1
Represents the year.
Numeric-expression2
Represents the month.
Numeric-expression3
Represents the day.
Returns a date from three given numbers: year, month and day
The year will be set according to the following:
0 <= YEAR < YEAR-LIMIT ...... year in the 21st. century
YEAR-LIMIT<= YEAR < 100 ..... year in the 20th. Century
If the resulting date is not valid, a null date will be returned.
The date format returned depends on the selected language:
English: "mm/dd/yy"
Portuguese: "dd/mm/yy"
Spanish: "dd/mm/yy"
Italian: "dd/mm/yy"
Note:
We suggest the use of this function instead of CTOD(). It does not vary with the language.
1. Using two digits for the year
&YY = 91
&MM = 10
&DD = 15
YMDTOD(&YY, &MM, &DD)
Result: 10/15/91 if English is set as the default Language.
2. Using four digits for the year
&YY = 1999
&MM = 08
&DD = 15
YMDTOD(&YY, &MM, &DD)
Result: 08/15/1999 if English is set as the default Language.
Set method
CTODFunction
YMDHMStoT function