Returns a FixStr value formatted as a date or time.
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.
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 |