The following table shows the date format constants you can use anywhere in your code in place of actual values.
Constant |
Value |
Description |
| vbGeneralDate | 0 | Display a date and/or time. For real numbers, display a data and time. If there is no fractional part, display only a date. If there is no integer part, display time only. Your system settings determine date and time display. |
| vbLongDate | 1 | Display a date using the long date format specified in your desktop computer's regional settings. |
| vbShortDate | 2 | Display a date using the short date format specified in your desktop computer's regional settings. |
| vbLongTime | 3 | Display a time using the long time format specified in your desktop computer's regional settings. |
| vbShortTime | 4 | Display a time using the short time format specified in your desktop computer's regional settings. |