Formatting Dates and Times

Formatting Dates and Times

A format string for date/time values can use one of the predefined string values shown in the following table.

String	Description
Long DateD	Displays a date in long date format.
Short Dated	Displays a date in short date format.
Long TimeT	Displays a date in long date format.
Short Timet	Displays a date in short date format.
F	Displays the long date and long time.
f	Displays the long date and short time.
g	Displays the short date and short time.
Mm	Displays the month and the day of a date.
Yy	Formats the date as the year and month.

---

Examples of applying a format string to date/time values are shown in the following table.

Format	Output
Format(Now,"D")	Thursday, November 29, 2007
Format(Now,"d")	11/29/2007
Format(Now,"T")	3:20:02 AM
Format(Now,"t")	3:20 AM
Format(Now,"F")	Thursday, November 29, 2007 3:20:02 AM
Format(Now,"f")	Thursday, November 29, 2007 3:20 AM
Format(Now,"g")	11/29/2007 3:20 AM
Format(Now,"m")	November 29
Format(Now,"y")	November, 2007