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
isNull
,TimeValue
returnsNull
.Both 12- and 24-hour clock formats are valid.
Any date information contained within
time
is ignored by theTimeValue
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.
See Also
CDate Function , TimeSerial Function |
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.