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.

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 |