1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. YEAR

The function YEAR converts a date or time period to a year in number format. 

This function is useful if you want to easily compare years to see if they're the same. 

Syntax

YEAR(Value to convert, [Time period method]) 

Arguments

ArgumentData typeDescription
Value to convertDate, Time periodThe date or time period to convert to a year, as a number.
Time period method (optional)KeywordDetermines whether to extract the year from the start, middle, or end of a time period.

The keywords for the time period method argument are:

  • START, the default method, returns the year for the first date in the time period
  • MID, which returns the year for the date in the middle of the time period
  • END, which returns the year for the last date in the time period

The YEAR function returns a number. 

Excel equivalent 

Related Anaplan functions

Examples

The example below shows YEAR(Value to convert). The values to convert are taken from the Product date, and Year period line items. The are date and time period formatted respectively. 


Key datesExpiry dates
Product released16/02/201623/08/2017
Year period Feb 16Aug 17

Product year

YEAR(Product released)

2,0162,017

Year number

YEAR(Year period)

2,0162,017

The next example shows YEAR(TIME. 'Period'). An explicit time reference is used instead of a line item. 


Key dates

Year Number 

YEAR(TIME. 'Apr 16')

2,016

The final example shows the effect of the Time period method argument. An explicit time reference is used with a keyword to determine which date in a time period to extract the year from.


Product: Plums
Start of fiscal yearWeek 1 FY2019

Year Start

YEAR(Start of fiscal year, START)

2,018

Year Mid

YEAR(TIME. 'FY19', MID)

2,019

Year End

YEAR(Start of fiscal year, END)

2,019