FormatDateTime Function
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Description
Returns an expression formatted as a date or time.
Syntax
FormatDateTime(Date[,NamedFormat])
The FormatDateTime function syntax has these parts:
Part |
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). |