Returns the number of milliseconds since
the epoch, given a time string.
Syntax
Time2Num(
d
[,
f
[,
k
]])
Parameters
Parameter
Description
d
A time string in the format supplied by
f
that
also conforms to the locale given by
k
.
f
(Optional)
A time format string. If you do not include
a value for
f
, the function uses the default time
format
H:MM:SS A
.
k
(Optional)
A locale identifier string that conforms
to the locale naming standards. If you do not include a value for
k
,
or if
k
is invalid, the function uses the ambient
locale.
The function returns a value of
0
if
any of the following conditions are true:
The format
of the given time does not match the format specified in the function.
Either the locale or time format supplied in the function
is invalid.
Insufficient information is provided to determine
a unique time since the epoch (that is, any information regarding
the time is missing or incomplete.
Examples
The
following expressions illustrate using the
Time2Num
function:
Expression
Returns
Time2Num("00:00:00 GMT", "HH:MM:SS Z")
1
Time2Num("1:13:13 PM")
76393001
to a user in California
on Pacific Standard Time, and
76033001
when that
same user is on Pacific Daylight Savings Time.