YEAR function

  • 21 December 2021
  • 0 replies
  • 74 views

Userlevel 3
Badge

 

Description

Returns the year value of the given date.

 

Syntax

Year (date)

 

Return type

Integer between 1 and 9999

 

Examples

 

Case

Results

Return Type

YEAR(DATE(2020, 12, 02))

2020

Integer

 

 


Excel equivalent: YEAR(serial_number)

See also:  MONTH, DAY


0 replies

Be the first to reply!

Reply