Description
The YEAR function finds the year of a given date.
Usage
YEAR(date)
| Argument | Type | Required | Description |
|---|---|---|---|
| date | date | yes | The date for which to find the year |
Remarks
The result will be a number representing the four-digit year.
Example
If your fiscal year starts in August, you can calculate the fiscal year from a TRAINING_DATE:
IF(MONTH(TRAINING_DATE) < 8, YEAR(TRAINING_DATE), YEAR(TRAINING_DATE) + 1)