Year / Temporal Layer

Extract year from date/datetime values, similar to datetime.year in Python or YEAR() in SQL. Returns four-digit year number.

Example contexts:

Date	Year	Type	Note
2024-01-01	2024	Leap Year	366 days
2023-12-31	2023	Common Year	365 days
2000-01-01	2000	Century Leap	Divisible by 400
1999-12-31	1999	Common Year	20th century end

Common applications:

Annual reporting
Year-over-year analysis
Long-term trends
Historical comparisons
Period aggregations

Table

Transforms

[, ...]

Select

column

Date/datetime column to extract year from. Returns four-digit year number following the Gregorian calendar system.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.