DATE function calculates a date value from a year, month, and day.
DATE(year, month, day)
|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)