Year

The Year function returns an integer representing the year component of a specified date and time.

Syntax

Year(date, [timezone])

Function arguments:


date	The date or column containing date values from which the year component is extracted.
timezone	[optional] The IANA time zone (e.g., `“America/Los_Angeles”`) to convert the date value to before extracting the year component. When the timezone argument is omitted, the input date is evaluated in UTC time.

💡
To learn how to create and use custom fiscal periods in Sigma, see How to create custom fiscal year and fiscal quarters.

Year(Date("2007-08-14"))

Extracts the year component from the specified date (August 14, 2007) and returns 2007 to represent the year.