Page Operations
Browse SpaceReturns the year of a date, an integer between 1583 and 9956.
Syntax
YEAR( 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: YEAR("6/21/69") | 1969 |
| report: YEAR("1969-6-21") | 1969 |
| BDate = "6/21/69" report: YEAR([BDate]) |
1969 |