MDY( )

The MDY( ) operator returns a value of the DATE data type from three integer operands that represent the month, the day of the month, and the year.

The MDY( ) operator converts to a single DATE format a list of exactly three valid integer expressions. The three expressions correspond with the month, day, and year elements of a calendar date:

The first expression must return an integer, representing the number of the month (1-12).

The second expression must return an integer, representing the number of the day of the month (1-28, 29, 30, or 31, depending on the month).

The third expression must return 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 within parentheses, separated by commas, just as you would if MDY( ) were a function.

The value of the third expression cannot be the abbreviation for the year. For example, 91 specifies a year in the first century, more than 1,900 years ago.

Reference

DATE( )