VBScript in a Nutshell, 2nd Edition

Name

FormatDateTime Function

Syntax

FormatDateTime(date[,format])

date

Use: Required

Data Type: Date or String

Any expression that can be evaluated as a date.

format

Use: Optional

Data Type: Long

Defines the format; see the list of values in “Rules at a Glance.”

Return Value

String

Description

Formats a date or time expression based on the computer’s regional settings.

Rules at a Glance

• The intrinsic constants to use for the format argument are:

  vbGeneralDate

  Value: 0

  Displays a date and/or time. If there is a date part, displays it as a short date. If there is a time part, displays it as a long time. If present, both parts are displayed. For example:

   MsgBox FormatDate Time(#04/10/03#, vbGeneralDate)

  displays 4/10/2003.

  VbLongDate

  Value: 1

  Uses the long date format specified in the client computer’s regional settings. For example:

  MsgBox FormatDate Time(#04/10/03#, vbLongDate)

  displays Thursday, April 10, 2003.

  VbShortDate

  Value: 2

  Uses the short date format specified in the client computer’s regional settings. For example:

  MsgBox FormatDate Time(#04/10/03#, vbShortDate)

  displays 4/102003.

  VbLongTime

  Value: 3

  Uses the time format specified in the computer’s regional settings. For example:

  MsgBox FormatDate Time(#1:03:00 PM#, vbLong Time)

  displays 1:03:00 PM.

  VbShortTime

  Value: 4

  Uses a 24-hour format (hh:mm). For example:

  MsgBox FormatDate Time(#1:03:00 PM#, vbShortTime)

  displays 13:03.

• The default date format is vbGeneralDate(0).

• These constants are all defined in the VBScript library and hence are an intrinsic part of ...