Year

Returns an integer representing the year component in a specified datetime value. Category: date Syntax:

Year([date_column])

Returns: IntColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`date_column`	`column\|datetime`	✓ Yes	The date to extract year from.

Allowed Column Types: DATETIME, DATE

Year([OrderDate])

Returns year from date.

Last modified on March 13, 2026