Description
The DAY function finds the day of the month of a given date.
Usage
DAY(date)
| Argument | Type | Required | Description |
|---|---|---|---|
| date | date | yes | The date for which to find the day |
Remarks
The result will always be in the range 1 and 31.
Example
In some cases you may want to accept only dates in the first half of the month. You can add a validation rule to ensure that the day of the month is the 15th or earlier:
DAY(reporting_date) <= 15