FormatDateTime Function

Returns a FixStr value formatted as a date or time.

Syntax

FormatDateTime([Date[,NamedFormat]])

The FormatDateTime function syntax has these parts:

Part Description
Date Optional. Date expression to be formatted.
NamedFormat Optional. Numeric value that indicates the date/time format used. If omitted, cdbGeneralDate is used.

If the Date argument is omitted, is a non-initialized variable, or Null, the function returns zero time and/or date.

Settings

The NamedFormat argument has the following settings:

Name Setting Description
cdbGeneralDate 0 Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.
cdbLongDate 1 Display a date using the long date format specified in your computer's regional settings.
cdbShortDate 2 Display a date using the short date format specified in your computer's regional settings.
cdbLongTime 3 Display a time using the time format specified in your computer's regional settings.
cdbShortTime 4 Display a time using the 24-hour format (hh:mm).


See Also

FormatNumber Function, Format Function