IsLeapYear / Temporal Layer

Determine if dates fall in leap years, similar to Python's calendar.isleap(). Returns boolean values indicating leap year status.

Leap Year Rules:

Year divisible by 4 is leap year
Century years (divisible by 100) are not leap years
Exception: Years divisible by 400 are leap years

Example evaluations:

Input Date	Is Leap Year
2024-01-15	true
2023-12-31	false
2000-06-30	true
2100-01-01	false

Common applications:

Calendar calculations
Date interval processing
Financial year analysis
Schedule planning
Date validation

Table

Transforms

[, ...]

Select

column

Date or datetime column to check for leap years. Input can be:

Date values (2024-01-15)
Datetime values (2024-01-15 14:30:00)
Timestamps with timezone Only the year component is considered.

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.