Shape · Dates and time

Extract Date/Time Parts

Pulls parts out of a date into new columns: year, quarter, month, week, day, weekday, hour, a weekend flag and more.

Also known as: Date part

How it works

Click Add part for each column and part you want. The parts are grouped: Date parts (Year, Month, Day, Quarter, Week of year, Day of year, Day of week, ISO weekday (Mon=1), ISO week-year, Is weekend), Time parts (Hour down to Microsecond) and Epoch (seconds). Day of week counts Sunday as 0 and Saturday as 6; ISO weekday counts Monday as 1 and Sunday as 7; Is weekend is true on Saturday and Sunday. Each part goes to a new column named <column>_<part> unless you type an output name, and the source column is kept. A null date gives null parts.

Inputs and outputs

Settings

extractions: [{column, component, outputColumn?}]

Example

You want sales by month and by weekday. Add Month and ISO weekday (Mon=1) on order_date, then group by the two new columns.

More in Dates and time

• Date/Time Arithmetic — Adds or subtracts time from a date, or measures the gap between two dates, from seconds to years or working days. For example, due date = order date + 30 days.
• Truncate Date/Time — Rounds dates down to the start of a period, such as the first of the month. Handy before grouping by month.
• Time of Day — Drops the date from a timestamp and keeps the clock time, so you can compare times across days.
• Make Date from Parts — Combines separate year, month and day columns (and hour, minute, second) into one real date or timestamp.
• Convert Date/Time to Text — Turns a date into text using a pattern, such as 01/03/2024 or Mar 2024. The result is text, so use it for labels and exports, not for date math.
• Convert Serial Date — Converts between numbers and dates: Unix timestamps, Excel serial dates, Julian days or your own starting point. For example, 45292 from Excel becomes 2024-01-01.
• Convert Timezone — Shifts times from one time zone to another, with daylight saving handled. For example, UTC to Europe/Warsaw.