The DATE function calculates a date value from a year, month, and day.


DATE(year, month, day)
Argument Type Required Description
year number Yes The full four-digit year of the date.
month number Yes The month of the date (1-12)
day number Yes The day of the month (1-31)


ActivityInfo supports dates between the year 1000 CE and 9999 CE.

If the given year, month, and day is not a valid date, then the result is blank.


When collecting dates, you may want to ensure that they fall into a specific date range, for example between January 2022 and July 2023.

TRAINING_DATE > DATE(2022,1,1) && TRAINING_DATE < DATE(2023,7,31)
Next item
AND (&&)