Returns a specified date as a character string in DD MONTH YY or DD MONTH YYYY format.

Syntax

DMY(<expD>)

<expD>

The date to format.

Description

DMY( ) returns a date in DD MONTH YY or DD MONTH YYYY format, where DD is the day number, MONTH is the full month name, and YY is the year number. If SET CENTURY is OFF (the default), DMY( ) returns the year as 2 digits. If SET CENTURY is ON, DMY( ) returns the year as 4 digits. If the day is only one digit, it is preceded by a space.

If you pass an blank date to DMY( ), it returns "0 Unknown 00" or "0 Unknown 0000".