Description
Returns an expression formatted as a date or time.

Syntax
FormatDateTime(Date[, NamedFormat])
The FormatDateTime function syntax has these parts:

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: vbGeneralDate
Value: 0
Description: 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.

Constant: vbLongDate
Value: 1
Description: Display a date using the long date format specified in your computer's regional settings.

Constant: vbShortDate
Value: 2
Description: Display a date using the short date format specified in your computer's regional settings.

Constant: vbLongTime
Value: 3
Description: Display a time using the time format specified in your computer's regional settings.

Constant: vbShortTime
Value: 4
Description: Display a time using the 24-hour format (hh:mm).