DateNum

(Engine-Level Function)

Description: Returns the number of days since January 1, 1970 for a given date.
Returns: Numeric
Usage: Script or steady state.
Function Groups: Time and Date
Related to: Date | Day | Month | Today | Year
Format: DateNum(Day, Month, Year)
Parameters:  
Day   
Required. Any numeric expression giving the day of the month for the date.
Month   
Required. Any numeric expression giving the month number for the date. January is month 1.
Year   
Required. Any numeric expression giving the year of the date. The full four-digit date must be used.
Comments: This function performs the inverse function to the Day, Month, and Year functions. No checks are done to verify that the parameters are in a valid range.

Example:

  NumDays = DateNum(14, 11, 1986);

NumDays is set to 6161, which is the number of days between 1 January 1970 and 14 November 1986.