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.