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

DAY

HOUR

MINUTE

MONTH

NOW

SECOND

TODAY

WEEKDAY