Function Description
| Category | Description |
|---|---|
| Syntax | YEAR(date) |
| Function | Returns the year value from a specified date. |
| Parameter | date: a specified date value Only date or datetime values are supported. |
| Number of Parameters | 1 |
| Parameter Type | Date or datetime |
| Return Value Type | Number |
Examples
| Formula | Result |
|---|---|
YEAR(DATE(2000,1,1)) | 2000 |
YEAR(TODATE("1999-01-01")) | 1999 |
More Examples
For example, you can use YEAR to get the year value from Start Time.
