MonthEnd / Temporal Layer
Roll dates forward to last day of their respective months, similar to pandas last_day_of_month or SQL LAST_DAY(). Preserves time components.
Example transformations:
| Input Date | Month End | Days Moved |
|---|---|---|
| 2024-01-15 10:30:00 | 2024-01-31 10:30:00 | +16 |
| 2024-02-01 00:00:00 | 2024-02-29 00:00:00 | +28 |
| 2024-04-15 23:59:59 | 2024-04-30 23:59:59 | +15 |
Common applications:
- Month-end reporting
- Financial closings
- Performance summaries
- Period-end balances
- Monthly reconciliations
Note: Accounts for varying month lengths (28/29 for February, 30/31 for others) while preserving time components.
Table
0
0
Table
Transforms
[, ...]Select
columnDate/datetime column to adjust to month ends. Each date will be moved to the last day of its respective month while maintaining its time components. Handles leap years correctly.
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.