Weekday / Temporal Layer
Extract ISO weekday number from date/datetime values, following ISO 8601 standard where Monday=1 through Sunday=7.
Example extractions:
| Date | DayNumber | Name | Note |
|---|---|---|---|
| 2024-01-01 | 1 | Monday | Week start |
| 2024-01-05 | 5 | Friday | Weekday end |
| 2024-01-07 | 7 | Sunday | Week end |
Common applications:
- Business day filtering
- Weekend identification
- Shift scheduling
- Operating hours
- Service availability
Table
0
0
Table
Transforms
[, ...]Select
columnDate/datetime column to extract weekday number from. Returns consistent day numbering regardless of locale or calendar system.
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.