FormatDateTime Function

Library

MSDN Library
Web Development
Scripting
Microsoft Windows Script Technologies
VBScript
VBScript Language Reference
Functions (VBScript)

Abs Function
Array Function
Asc Function
Atn Function
CBool Function
CByte Function
CCur Function
CDate Function
CDbl Function
Chr Function
CInt Function
CLng Function
Conversion Functions
Cos Function
CreateObject Function
CSng Function
CStr Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
Escape Function
Eval Function
Exp Function
Filter Function
FormatCurrency Function

FormatDateTime Function

FormatNumber Function
FormatPercent Function
GetLocale Function
GetObject Function
GetRef Function
Hex Function
Hour Function
InputBox Function
InStr Function
InStrRev Function
Int, Fix Functions
IsArray Function
IsDate Function
IsEmpty Function
IsNull Function
IsNumeric Function
IsObject Function
Join Function
LBound Function
LCase Function
Left Function
Len Function
LoadPicture Function
Log Function
LTrim; RTrim; and Trim Functions
Math Functions
Mid Function
Minute Function (VBScript)
Month Function
MonthName Function
MsgBox Function
Now Function
Oct Function (VBScript)
Replace Function
RGB Function
Right Function
Rnd Function
Round Function
ScriptEngine Function
ScriptEngineBuildVersion Function
ScriptEngineMajorVersion Function
ScriptEngineMinorVersion Function
Second Function
SetLocale Function
Sgn Function
Sin Function
Space Function
Split Function
Sqr Function
StrComp Function
String Function
StrReverse Function
Tan Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
TypeName Function
UBound Function
UCase Function
Unescape Function
VarType Function
Weekday Function
WeekdayName Function
Year Function

Related Links

VBScript User's Guide
VBScript Language Reference

FormatDateTime Function
This page is specific to:.NET Framework Version:2.03.0

Visual Basic Scripting Edition

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

Remarks

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

Requirements

See Also

Reference

FormatCurrency Function

FormatNumber Function

FormatPercent Function

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement

Rate the Lightweight library

x

Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.

Do you like the SearchBox?

Yes

No

Do you like the tabbed code blocks?

Yes

No

How useful is this topic?

Tell us more.

Thanks

x

You're helping to improve MSDN Online.

Switch View

Lightweight Beta