 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
 |
 |
 |
|
||||||||||||||||||
 |
 |
 |
 |
 |
 |
 |
|
|||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Returns an expression formatted as a date or time.
FormatDateTime(Date[,NamedFormat])
Date
The date expression to be formatted. Required.
NamedFormat
A numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used. Optional.
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). |
The following example uses the FormatDateTime function to format the expression as a long date and assign it to MyDateTime:
Function GetCurrentDate
' FormatDateTime formats Date in long date.
GetCurrentDate = FormatDateTime(Date, 1)
End Function
Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.