Skip to main content
You can use the Date Transform tool to extract parts of date columns - such as a weekday or year. It is particularly helpful in combinations with others tools. Such as a Filter to keep transactions from the current year or a Group By + Combine to merge datasets by Year/Month.
Note that our Syntax also supports date trunc calculations (same as Date Transform). See more in the Syntax section.

​
Configuration

1

Datetime column(s)

Select the Datetime column(s) from which you want to extract part of the date
2

Format(s)

Select the parts of the you want to extract. You can choose from the following:
  • Date: helpful if you just want to the date from a column that has timestamps
  • Hour: extract the hour from the timestamp
  • Minute: extract the minute from the timestamp
  • Second: extract the second from the timestamp
  • Week: extract the ISO week from a date
  • Weekday: extract the weekday from a date (1 = Monday)
  • Day of year: extract the day of the year from a date (1 = January 1st)
  • Month: extract the month from a date (1 = January)
  • Month Name: extract the month name from a date (e.g. January)
  • First Day of Month: get the first day of a given month from a date (e.g. 2024-10-10 → 2024-10-01)
  • Last Day of Month: get the last day of a given month from a date (e.g. 2024-10-10 → 2024-10-31)
  • Quarter: extract the quarter that a date is in
  • Year: extract the year of a date (e.g. 2024-10-10 → 2024)
  • Is Leap Year: extract whether a date is in a leap year (e.g. 2024-10-10 → TRUE)
  • Epoch: extract the epoch from a date (e.g. 2024-10-10 → 1728518400)