Microsoft Office Tutorials and References
In Depth Information
8.6.3 The Format Function
DateAdd, DateDiff, DatePart
Perform date calculations.
DateSerial, DateValue
Return a date.
TimeSerial, TimeValue
Return a time.
Date, Time
Set the date or time.
Timer
Time a process.
8.6.3 The Format Function
The Format function is used to format strings, numbers, and dates. Table 8-3 g ives a few
examples.
Table 8-3. Format Function Ex amples
Expression
Return value
Format(Date, "Long Date")
Thursday, April 30, 1998
Format(Time, "Long Time")
5:03:47 PM
Format(Date, "mm/dd/yy hh:mm:ss AMPM")
04/30/98 12:00:00 AM
Format(1234.5, "$##,##0.00")
$1,234.50
Format("HELLO", "<")
"hello"
 
Search JabSto ::




Custom Search