Livecycle

Num2Date

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

Num2Date