The date function creates a date of a specific value of the user’s choosing.

 

Syntax

 

DATE(x,y,z)

 

Parameters

 

= Year as a 4-digit integer.

 

y = Month as an integer between 1 and 12.

 

z = Day as an integer between 1 and 31.

 

Type of Data Returned

 

The date function will return a date.

 

Examples

 

DATE(2019,8,22) will return 22nd of August 2019.

 

Instead of using a date attribute on an item, using a specific date value to assess if items are “late” or “on-time” against the current date.

 

IF(TODAY()>DATE(2019,8,22), “late”, “on-time”)

 

Use the DATE() function to build a date out of NUMBERS E.g. DATE(2019, 12, 2) for '2 Dec 2019'

 

Note that unlike NUMBERs there are rules about the order of calculation for dates.

 

DATE1 - DATE2 = NUMBER OF DAYS (where Date1 is chronologically earlier than Date2)

 

DATE2 - DATE1 = -NUMBER OF DAYS (where Date1 is chronologically earlier than Date2)

 

DATE + DATE = INVALID

 

NUMBER + DATE = INVALID

 

DATE + NUMBER = DATE (Number assumed to be days). 

 

Multiply and Divide are not valid operators.

 

See also TODAY(), ADDDAYS(), ADDMONTHS() operators.