Returns the specified date or datetime expression in month-day-year format with the name of the month spelled out.
Syntax
MDY(dExpression | tExpression)
Returns
Character
Arguments
dExpression
Specifies the date expression to return in month-day-year format.
tExpression
Specifies the datetime expression to return in month-day-year format.
Remarks
If SET CENTURY is OFF, the character expression is returned in a month dd, yy format. If SET CENTURY is ON, the format is month dd, yyyy.