The
mdy operator returns a DATE value derived from three integers that represent
the month, day of the month, and year of a calendar date.
DateTimeLib.mdy(
month INT in,
day INT in,
year INT in)
returns (result DATE)
- result
- A DATE value.
- month
- An integer in the range 1 through 12, representing the month.
- day
- An integer representing the day of the month in the range 1 through 28,
29, 30, or 31, depending on the month.
- year
- A four-digit integer representing the year.
An error results if you specify values outside the range
of days and months in the calendar or if the number of operands is not three.
You must enclose the three integer expression operands between parentheses,
separated by commas, just as you would if MDY( ) were a function. The third
expression cannot be the abbreviation for the year. For example, 99 specifies
a year in the first century, approximately 1,900 years ago.