Returns the day of the month for a date, 1 through 31.
Syntax
| Code Block |
|---|
DAY( date ) |
date
format: month/day/year or year-month-day
year (required) - An integer between 1583 and 9956, or 0 - 99.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month.
Examples
Syntax | Result |
|---|---|
report: DAY("6/21/69") | 21 |
report: DAY("1969-6-21") | 21 |
BDate = "6/21/69" (string) | 21 |