Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Function Declaration
-
Function FormatDateTime(Expression As Variant, NamedFormat As VbDateTimeFormat = vbGeneralDate) As String
|
Parameter |
Description |
|---|---|
|
Expression |
Variant containing a Date expression to be formatted. |
|
NamedFormat |
Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used. |
Runtime Semantics.
§ Returns an expression formatted as a date or time.
§ The NamedFormat argument has the following settings:
|
Constant |
Value |
Description |
|---|---|---|
|
vbGeneralDate |
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. |
|
vbLongDate |
1 |
Display a date using the implementation-defined long date format. |
|
vbShortDate |
2 |
Display a date using the implementation-defined short date format. |
|
vbLongTime |
3 |
Display a time using the implementation-defined time format. |
|
vbShortTime |
4 |
Display a time using the 24-hour format (hh:mm). |