Section B.4. Date Format Constants
B 4 Date Format Constants
The FormatDateTime function allows you to specify the format in which a date or time is displayed by choosing one of the date format constants to supply to its NamedFormat parameter:
Constant |
Value |
Description |
---|---|---|
vbGeneralDate |
0 |
Display a date in short date format and a time in long time format. If present, both parts are displayed. |
vbLongDate |
1 |
Use the long date format defined in the local computer's regional settings. |
vbLongTime |
3 |
Use the long time format defined in the local computer's regional settings. |
vbShortDate |
2 |
Use the short date format defined in the local computer's regional settings. |
vbShortTime |
4 |
Use the short time format defined in the local computer's regional settings. |