The date function creates a date of a specific value of the user’s choosing.
Syntax
DATE(x,y,z)
Parameters
x = 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.