Name

TimeValue Function

Syntax

TimeValue(time)
time

Use: Required

Data Subtype: String

Any valid string representation of a time.

Return Value

A Variant of subtype Date.

Description

Converts a string representation of a time to a Variant Date subtype.

Rules at a Glance

  • If time is invalid, a runtime error is generated.

  • If time is Null, TimeValue returns Null.

  • Both 12- and 24-hour clock formats are valid.

  • Any date information contained within time is ignored by the TimeValue function.

  • If TimeValue will return invalid time information, an error occurs.

Programming Tips & Gotchas

  • A time literal can also be assigned to a Variant or Date variable by surrounding the date with hash characters (#), as the following snippet demonstrates:

    Dim dMyTime
    dMyTime = #12:30:00 AM#
  • The CDate function can also cast a time expression contained within a string as a Date variable, with the additional advantage of being internationally aware.

Get VBScript in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.