DATETODAYS Function
Computes the number of days from January 1, 1900, to the given date.
Usage
result = DATETODAYS([day[, month[, year]]])
Input Parameters
day—Day of the input date.
month—Month of the input date.
year—Year of the input date. The year 1950 corresponds to the year 1950 A.D., and the year 50 corresponds to year 50 A.D.
Returned Value
result—Number of days from January 1, 1900, to the given date. If negative, it indicates the number of days prior to January 1, 1900.
Discussion
Function DATETODAYS returns the number of days from January 1, 1900, to the given date and returns negative values for days prior to January 1, 1900. A negative year can be used to specify B.C. Input dates in year 0 and for October 5, 1582, through October 14, 1582, inclusive, do not exist; consequently, in these cases, DATETODAYS issues an error.
The Gregorian calendar starts the first day after October 4, 1582, which became October 15, 1582. Prior to that, the Julian calendar was in use.
Example
The following example uses DATETODAYS to compute the number of days from January 15, 1986, to February 28, 1986.
d0 = DATETODAYS(15, 1, 1986)
d1 = DATETODAYS(28, 2, 1986)
PM, d1 - d0, Title = 'Number of days from 1/15/86 to 2/28/86'
