MDY()

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

MDY() operator takes three valid integer expressions and converts them to a single DATE format.

These three expressions must correspond with the month, day, and year elements of a calendar date:

• The 1st expression must return an integer from 1 to 12 that represents the number of a month.
• The 2nd must return an integer from 1 to 31 that represents the number of the day in a month (depends on the month).
• The 3rd must return a four-digit integer that represents a year.

For example,

LET my_date = MDY(12, 12, 2018)

LET my_date = MDY(06/3, 3+9, 2025-5)

LET my_date = MDY(a, b, c)

The operands must be separated by commas.

If you specify values outside the expected ranges of days and months in the calendar, the expression will be invalid and will return NULL.

If you use WHENEVER ANY ERROR CONTINUE and display status, you will learn that incorrectly specified values cause these errors:

• -1204. Invalid year in date,
• -1205. Invalid month in date, or
• -1206. Invalid day in date.

The third operand cannot be an abbreviation for the year. For example, if you enter 18, 4GL will consider it as 18 AD and not 2018 AD.