# Normalize date granularity

The Normalize Date granularity step allows to extract date information (eg. *day*, *week*, *year* etc.) in a column intended for aggregation.

### Step parameters

* `Date column` **(string\*)**: the column on which the date granularity must be applied
* `Date granularity to apply` **column(string)\***: Among ( year, quarter number, month, ISO week (monday to monday), week (sunday to sunday) you can choose one or more date granularity to apply.
* `New column` **column(string)\***: the ending date

{% hint style="info" %}
The following granularities are supported:

* `year`: calendar date corresponding to the first day (1st of January) of the year
* `quarter`: calendar date corresponding to the first day of the quarter
* `month`: calendar date corresponding to the first day of the month
* `week`: calendar date corresponding to the first day of the week (sunday)
* `isoWeek`: calendar date corresponding to the first day of the week (monday)
* `day`: calendar date corresponding to the first hour of the day
  {% endhint %}

### Example

**Input**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-019d9a4f6b06a48caf1299557990d042654799b9%2FCapture%20d%E2%80%99e%CC%81cran%202025-04-23%20a%CC%80%2017.06.25.png?alt=media" alt=""><figcaption><p>Date - Normalize date granularity input</p></figcaption></figure>

**Configuration**

```json
{
  "column": "date",
  "granularity": "year",
  "new_column": "aggregated_date_column",
}

```

**Output**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-7df204e9a40f612f7aba091c61b8bdad43717873%2FCapture%20d%E2%80%99e%CC%81cran%202025-04-28%20a%CC%80%2017.25.45.png?alt=media" alt=""><figcaption><p>Date - Normalize date granularity output</p></figcaption></figure>