VbDateTimeFormat

Format codes for the FormatDateTime function.

Constant Value Description
vbGeneralDate 0 Display a date and/or time. For real numbers, display a date and time; if there is no fractional part, display a date only; if there is no integer part, display a time only. Date and time display is determined by your system settings.
vbLongDate 1 Display a date in the long date format specified by the system regional settings.
vbShortDate 2 Display a date in the short date format specified by the system regional settings.
vbLongTime 3 Display a time in the long time format specified by the system regional settings.
vbShortTime 4 Display a time in the short time format specified by the system regional settings.

See Also

License: CC-BY-4.0 Code license: MIT Attribution: VBA-Docs