FormatDateTime |
Top Previous Next |
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"
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" |