|
Returns
a date string, given a number of days since the epoch.
SyntaxNum2Date(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.
ExamplesThe
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
|
|
|
|
