Description
The DATE function calculates a date value from a year, month, and day.
Usage
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) |
Remarks
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.
Example
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)