O'Reilly logo

VBScript in a Nutshell, 2nd Edition by Ron Petrusha, Matt Childs, Paul Lomax

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required