NGWS SDK Documentation  

This is preliminary documentation and subject to change.
To comment on this topic, please send us email at ngwssdk@microsoft.com. Thanks!

FormatDateTime Function

Returns an expression formatted as a date or time.

FormatDateTime(Date[,NamedFormat])

Arguments

Date
Required. Date expression to be formatted.
NamedFormat
Optional. Numeric value that indicates the date/time format used. If omitted, GeneralDate is used.

Settings

The NamedFormat argument has the following settings:

Constant Value Description
GeneralDate 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.
LongDate 1 Display a date using the long date format specified in your computer's regional settings.
ShortDate 2 Display a date using the short date format specified in your computer's regional settings.
LongTime 3 Display a time using the time format specified in your computer's regional settings.
ShortTime 4 Display a time using the 24-hour format (hh:mm).

See Also

FormatCurrency Function | FormatNumber Function | FormatPercent Function