Logo Docs
Logo Docs

YEAR

Returns the year for a given date as a number

Usage

YEAR(date)

Parameters

date

(Required) The date from which to extract the year

Examples

Example With these variables Result

YEAR(event_date)
event_date is DATE(2024, 5, 28)

2024

YEAR(DATE(1990, 1, 12))

 (None)

1990

Reminders

A text containing a date is not handled as a date. To have an actual date:

  • use the @DATE_QUESTION to set the variable
  • use a function that converts to a date: DATEVALUE(text_date)
  • use a function that returns a date: TODAY() or DATE(year, month, day)

See also