Date
Date Parts
Adds columns holding parts of a date — its year, quarter, month name or number, ISO week, weekday, day, whether it is a weekend, hour or Unix time.
When to use it
Use it before grouping or filtering by period: sales per quarter, orders on weekends, sign-ups per ISO week.
In a pipeline
File InputDate PartsSummarize (Multi-Aggregate)
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Parts | text | — | year, month_num, day |
| From Format | select | — | AUTO |
Example
Year, quarter, month and weekday
- Column=OrderDate
- Parts=year, quarter, month_num, weekday
| Order | OrderDate |
|---|---|
| A-1 | 2026-10-15 |
| A-2 | 2026-10-17 |
| Order | OrderDate | OrderDate_year | OrderDate_quarter | OrderDate_month_num | OrderDate_weekday |
|---|---|---|---|---|---|
| A-1 | 2026-10-15 | 2026 | 4 | 10 | Thursday |
| A-2 | 2026-10-17 | 2026 | 4 | 10 | Saturday |
Worth knowing
- Parts: year, quarter, month (name), month_num, week (ISO 8601, weeks start Monday), weekday (name), day, is_weekend (true/false), hour, unix (seconds).
- New columns are named <column>_<part> and added at the end, in the order you list the parts.
- Blank or unreadable dates give blank parts; set From Format when the dates are not in an auto-detected form.