Previous PageNext Page

8.4.28 FormatDateTime Function

Returns an expression formatted as a date or time.
 

Syntax

FormatDateTime(Date[,NamedFormat])

Arguments

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.

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).
 


Copyright © 2000 Chili!Soft

Previous PageTop Of PageNext Page