> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Date Transform

> Extract part of date columns to new formats

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](/tools/basics/filter) to keep transactions from the current year or a [Group By](/tools/reshape/group-by) + [Combine](/tools/merge/combine) to merge datasets by Year/Month.

<Note>
  Note that our Syntax also supports date trunc calculations (same as Date Transform). See more in the [Syntax](/canvas/syntax) section.
</Note>

### Configuration

<Steps>
  <Step title="Datetime column(s)">
    Select the Datetime column(s) from which you want to extract part of the date
  </Step>

  <Step title="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)
  </Step>
</Steps>