Description Returns an expression formatted as a date or time. Syntax FormatDateTime(Date[, NamedFormat]) The FormatDateTime function syntax has these parts: Date - Required. Date expression to be formatted. NamedFormat - Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used. Settings The NamedFormat argument has the following settings: Constant: vbGeneralDate Value: 0 Description: 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. Constant: vbLongDate Value: 1 Description: Display a date using the long date format specified in your computer's regional settings. Constant: vbShortDate Value: 2 Description: Display a date using the short date format specified in your computer's regional settings. Constant: vbLongTime Value: 3 Description: Display a time using the time format specified in your computer's regional settings. Constant: vbShortTime Value: 4 Description: Display a time using the 24-hour format (hh:mm).