DMY( ) Function

Returns a character expression in day-month-year format (for example, 31 May 1998) from a Date or DateTime expression. The month name isn't abbreviated.

DMY(dExpression | tExpression)

Return Value

Character

Parameters

  • dExpression
    Specifies the Date expression from which DMY( ) returns a character string in day-month-year format.

  • tExpression
    Specifies the DateTime expression from which DMY( ) returns a character string in day-month-year format.

Remarks

If SET CENTURY is OFF, DMY( ) returns a character string in a dd-Month-yy format (for example, 16 February 98). If SET CENTURY is ON, the format is dd-Month-yyyy (for example, 16 February 1998).

Example

CLEAR
SET CENTURY OFF
? DMY(DATE( ))
SET CENTURY ON
? DMY(DATE( ))

See Also

Reference

MDY( ) Function

SET CENTURY Command

SET DATE Command

Other Resources

Functions

Language Reference (Visual FoxPro)