Returns
a date string, given a number of days since the epoch.
Syntax
Num2Date(
n
[,
f
[,
k
]])
Parameters
Parameter
|
Description
|
n
|
An integer representing the number of days.
If
n
is
invalid, the function returns an error.
|
f
(Optional)
|
A date format string. If you do not include
a value for
f
, the function uses the default date
format
MMM D, YYYY
.
|
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 date does not match the format specified in the function.
-
Either the locale or date format supplied in the function
is invalid.
Insufficient information is provided to determine
a unique day since the epoch (that is, any information regarding
the date is missing or incomplete.
Examples
The
following expressions are examples of using the
Num2Date
function:
Expression
|
Returns
|
Num2Date(1, "DD/MM/YYYY")
|
01/01/1900
|
Num2Date(35139, "DD-MMM-YYYY", "de_DE")
|
16-Mrz-1996
|
Num2Date(Date2Num("Mar 15, 2000") - Date2Num("98-03-15", "YY-MM-DD", "fr_CA"))
|
Jan 1, 1902
|
|
|
|