Export (0) Print
Expand All
6 out of 14 rated this helpful - Rate this topic

Predefined Date/Time Formats (Format Function)

The following table identifies the predefined date and time format names. These may be used by name as the style argument for the Format function:

Format Name Description
General Date, or G Displays a date and/or time. For real numbers, display a date and time; for example, 4/3/93 05:34 PM.If there is no fractional part, display only a date, for example, 4/3/93. If there is no integer part, display time only, for example, 05:34 PM. Date display is determined by your system's LocaleID value.
Long Date, or D Displays a date according to your locale's long date format.
Medium Date Displays a date using the medium date format appropriate for the language version of the host application.
Short Date, or d Displays a date using your locale's short date format.
Long Time, or T Displays a time using your locale's long time format; includes hours, minutes, seconds.
Medium Time Displays time in 12-hour format using hours and minutes and the AM/PM designator.
Short Time, or t Displays a time using the 24-hour format, for example, 17:45.
f Displays the long date and short time according to your locale's format.
F Displays the long date and long time according to your locale's format.
g Displays the short date and short time according to your locale's format.
M, m Displays the month and the day of a date.
R, r Formats the date and time as Greenwich Mean Time (GMT)
s Formats the date and time as a sortable index.
u Formats the date and time as a GMT sortable index.
U Formats the date and time with the long date and long time as GMT.
Y, y Formats the date as the year and month.

Requirements

Namespace: Microsoft.VisualBasic

Module: Strings

Assembly: Microsoft Visual Basic .NET Runtime (in Microsoft.VisualBasic.dll)

See Also

Format Function | Predefined Numeric Formats (Format Function) | User-Defined Date/Time Formats (Format Function)

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.