FormatDateTime

Function	Parameters	Return value
FormatDateTime	DateTime value	string

Formats the specified value as a date/time, using the Windows regional settings. This function does not include neutral values in the resulting string.

Example:

FormatDateTime(#1/1/2009#) = "01/01/2009"
FormatDateTime(#1/1/2009 1:30#) = "01/01/2009 1:30:00 AM"
FormatDateTime(#1:30#) = "1:30:00 AM"

Function	Parameters	Return value
FormatDateTime	DateTime value,``string format	string

Formats the specified value as a date/time, using the named format specified in the "format" parameter. The valid values for this parameter are:

"Long Date"

"Short Date"

"Long Time"

"Short Time"

Example:

FormatDateTime(#1/1/2009 1:30#, "Long Date") = "Thursday, January 01, 2009"
FormatDateTime(#1/1/2009#, "Short Date") = "01/01/2009"
FormatDateTime(#1:30#, "Short Time") = "01:30 AM"
FormatDateTime(#1:30#, "Long Time") = "1:30:00 AM"