Description

The FormatDateTime() function formats and returns a valid date or time expression.

This function has the form:

FormatDateTime(date,format)

Parameter	Description
date	(required) Any valid date expression (like Date() or Now())
format	Optional. A value that specifies the date/time format to use. Can take the following values: 0 = vbGeneralDate - Default. Returns date: mm/dd/yy and time if specified: hh:mm:ss PM/AM. 1 = vbLongDate - Returns date: weekday, monthname, year 2 = vbShortDate - Returns date: mm/dd/yy 3 = vbLongTime - Returns time: hh:mm:ss PM/AM 4 = vbShortTime - Return time: hh:mm

Examples

Display a date in different formats:

The following example shows the basic use of this function:

d = CDate("2010-02-16 13:45")
Msgbox(FormatDateTime(d))
Msgbox(FormatDateTime(d,1))
Msgbox(FormatDateTime(d,2))
Msgbox(FormatDateTime(d,3))
Msgbox(FormatDateTime(d,4))

This produces the following result (each line in a separate pop-up message box):

Miscellaneous Information

Supported in Version:	2.0