Formatdatetime function

Returns an expression formatted as a date or time.

Syntax

FormatDateTime( Date [, NamedFormat ] )

The FormatDateTime function syntax has these arguments:

Argument	Description
Date	Required. Date expression to be formatted.
NamedFormat	Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.

Settings

The NamedFormat argument has the following settings:

Constant	Value	Description
vbGeneralDate	0	Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.
vbLongDate	1	Display a date using the long date format specified in your computer's regional settings.
vbShortDate	2	Display a date using the short date format specified in your computer's regional settings.
vbLongTime	3	Display a time using the time format specified in your computer's regional settings.
vbShortTime	4	Display a time using the 24-hour format (hh:mm).

Examples

Expression	Results
SELECT FormatDateTime([DateTime],0) AS Expr1 FROM ProductSales;	Formats and displays the date values in "DateTime" field into Date and/or time.
SELECT FormatDateTime([DateTime],1) AS NewDate FROM ProductSales;	Formats and displays the date values in "DateTime" field as Long Date format. Formats and displays the date values in "DateTime" field as Short Date format.
SELECT FormatDateTime([DateTime],3) AS NewDate FROM ProductSales;	Formats and displays the date values in "DateTime" field as "Time" format (without the date).
SELECT FormatDateTime([DateTime],4) AS NewDate FROM ProductSales;	Formats and displays the date values in "DateTime" field as 24hour "Time" format (without the date).