Skip to main content

Extract date part

This task allows you to extract parts of date from a date column.


Let us start with the following data:

Birthdays → View 1


Let us assume we would like to know which day of the week these people were born in. We want to get the weekdays out of this.

Expected output data will look like this.

Birthdays → View 1


We can achieve that by doing the following:

  1. Go to Transform > Date Functions.
  2. Select the function Extract Date Part.
  3. Choose the column Date.
  4. Choose the option Weekday in the selection for What to extract.
  5. Enter the name Weekday in the result column section.
  6. Hit APPLY.

Supported Options

The following options are supported by this task.

  • Extract date from: The column to extract date from.
  • What to Extract: The component of the date to extract.
  • Apply result into: This option allows configuration of the destination of the results by this task. See result documentation.
ComponentExtracted Data TypeDescriptionExample
YearNumericThe year part of date2015
MonthNumericMonth as a number between 1-127
Month NameTextEnglish name of the MonthJanuary
Month & YearTextMonth as Text and YearAugust, 2012
Date Part without timeTextDate Part ignoring time1989-07-12
Time Part without DateTextJust the Time part of the date00:00:00
QuarterNumericQuarter of the year3
WeekdayTextEnglish day of weekMonday
Day of YearNumericThe day of the year as a number between 1-366234
DayNumericThe day of the month12
HourNumericHour of day between 0 & 2311
MinuteNumericMinute of the hour between 0 & 5923
SecondNumericSecond of the minute between 0 & 5946