Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the specified date or datetime expression in month-day-year format with the name of the month spelled out.
MDY(dExpression | tExpression)
Return Values
Character
Parameters
- 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.
Example
The following example creates a user-defined function that returns a date with the corresponding weekday.
SET CENTURY OFF
CLEAR
? Longdate({^1998-02-16}) && Displays Monday, February 16, 98
SET CENTURY ON
? Longdate({^1998-02-16}) && Displays Monday, February 16, 1998
*** LongDate ***
FUNCTION longdate
PARAMETERS gdDate
RETURN CDOW(gdDate) + ', ' + MDY(gdDate)