OrdinalDay / Temporal Layer
Extract day of year (ordinal day) from date/datetime values, similar to datetime.timetuple().tm_yday in Python or DAYOFYEAR() in SQL. Returns integers from 1 to 366.
Example calculations:
| Date | Ordinal | Quarter | Note |
|---|---|---|---|
| 2024-01-01 | 1 | Q1 | New Year's Day |
| 2024-02-29 | 60 | Q1 | Leap Year Feb 29th |
| 2024-07-04 | 186 | Q3 | US Independence Day |
| 2024-12-31 | 366 | Q4 | Year end (leap year) |
| 2023-12-31 | 365 | Q4 | Year end (normal year) |
Common applications:
- Day-of-year analysis
- Seasonal tracking
- Agricultural planning
- Climate studies
- Project timeline tracking
- Annual progress monitoring
Note: Accounts for leap years automatically. February 29th affects all subsequent ordinal days in leap years.
Table
0
0
Table
Select
columnDate/datetime column to extract ordinal day from. System automatically handles:
- Regular years (1-365)
- Leap years (1-366)
- Different month lengths Counts days from January 1st.
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.