Skip to main content
Returns an integer representing the year component in a specified datetime value. Category: date Syntax:
Year([date_column])
Returns: IntColumn Context Filtering: ✓ Yes

Parameters

NameTypeRequiredDescription
date_columncolumn|datetime✓ YesThe date to extract year from.
Allowed Column Types: DATETIME, DATE

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

Year([OrderDate])
Returns year from date.
Last modified on March 13, 2026