YEAR
Description
YEAR returns the year that corresponds to the supplied date.
Syntax
YEAR ( serial_number )
Parameter |
Description |
serial_number |
The date as a serial number or as text (for example, 06-21-94 or 21-Jun-94). |
Examples
This function returns 1993:
YEAR(34328)
This function returns 1994:
YEAR("06/21/94")
Also, see