IsoYear / Temporal Layer
Extract ISO 8601 year from dates, which may differ from calendar year for dates near year boundaries. ISO years ensure consistent week numbering across years.
Example conversions:
| Date | Calendar Year | ISO Year | Note |
|---|---|---|---|
| 2024-01-01 | 2024 | 2024 | Regular date |
| 2023-12-31 | 2023 | 2023 | Last ISO week |
| 2024-01-01 | 2024 | 2023 | Part of previous year's last week |
| 2024-12-30 | 2024 | 2025 | Part of next year's first week |
Common applications:
- Week-based fiscal calendars
- International standards compliance
- Cross-year reporting
- Industrial production planning
- Retail week calculations
Table
0
0
Table
Transforms
[, ...]Select
columnDate or datetime column to extract ISO year from. Handles:
- Standard dates
- Datetime values
- Timezone-aware timestamps Year determination follows ISO 8601 week dates standard.
AsColumn
nameName 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.