Previous Topic: DATE Function

Next Topic: Usage Notes for the DATE Function

Valid DATE Formats

Following are examples of specifying dates, assuming today is March 20, 2009:

Sample Statement

Value Returned

DATE()

20 Mar 2009' (Defaults to today's date)

DATE('D')

'09'

DATE('N','2003080')

'21 Mar 2009'

DATE('U','20030322','S')

'03/22/09'