Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns an expression formatted as a date or time.
Syntax
FormatDateTime(Date[, NamedFormat])
Arguments
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). |
Remarks
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
Requirements
See Also
FormatCurrency Function
FormatNumber Function
FormatPercent Function