DAYS: Obtaining the Number of Days Since January 1, 0001

How to:

The DAYS function returns 1 more than the number of days from January 1, 0001 to the provided date value.


Top of page

x
Syntax: How to Obtain the Number of Days Since January 1, 1900
DAYS(arg)

where:

arg

Date or timestamp

Is the input argument.

This function returns an integer value.



Example: Obtaining the Number of Days Since January 1, 1900

DAYS returns one more than the number of days since January 1, 1900.

DAYS('2000-01-01') 

returns 730120.


iWay Software