FormatDateTime

Returns an expression formatted as a date or time.

Structure

FormatDateTime(Date[, NamedFormat])

Parameters

Date - Required. Date expression to be formatted.

NamedFormat - Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.

Parameter Values

The NamedFormat argument has the following values:

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).

Example

The following example uses the FormatDateTime function to format the expression as a long date and assign it to MyDateTime:

Function GetCurrentDate

' FormatDateTime formats Date in long date.

GetCurrentDate = FormatDateTime(Date, 1)

End Function |