Year()

Home   Back   Next  

Working with Formulas > Functions Used in Formulas > Date/Time Functions > Year()

 

YEAR() returns the numeric year value for a given date expression. If a null date is specified, the function returns zero.

 

 

Function Format

 

YEAR(date) 

 

 

Return Value

 

YEAR() returns an integer 

 

 

Examples

 

YEAR(DATE("11/03/2007")) = 2007 

 

YEAR(DATE(2007, 12, 25)) = 2007