MDY( ) Function

Example   See Also

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.