FormatDateTime Function |
Main Menu |
Syntax
FormatDateTime(Date[,NamedFormat])
The FormatDateTime function syntax has these parts:
Part | Description |
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 | 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 long date format specified in your computer's regional settings. |
vbShortDate | 2 | Display a date using the short date format specified in your computer's regional settings. |
vbLongTime | 3 | Display a time using the time format specified in your computer's regional settings. |
vbShortTime | 4 | Display a time using the 24-hour format (hh:mm). |
For example.
Dim whatsthetime, whatsthedate
whatsthedate = FormatDateTime(Now(),1) ' whatsthedate
would contains something like "03 May 2005"
whatsthetime = FormatDateTime(Now(),3) ' whatsthetime
could contain "17:40:01"
This of course would have regional variation and differences in the time and data dependent upon the local time and data to the system running the Visual Basic Script or ASP at the time.
whatsthedate
= FormatDateTime(Now(),2) '
whatsthedate might contains something like "03/05/2005"
whatsthetime = FormatDateTime(Now(),4) ' whatsthetime
might contain "17:45"
related to
FormatCurrency FormatNumber
FormatPercent
|