---
schema_version: "1"
id: 8b1bc6e14fa3598e39537e2f1b075ac0544837b418ab1f6c6118a70270ce8a65
title: Categorize Date Field Values into Buckets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_bucket_date_field.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_bucket_date_field.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2c8473c1197eb073f26af05d6f6841341760ae3338ff3f502f9a219792296388
description: Use a transformation to create a calculated field based on a formula. You add transformations inside a Transform node. You can string together multiple transformations to manipulate data sequentially.
products:
  - Data 360
release: "264"
---
# Categorize Date Field Values into Buckets

Use a transformation to create a calculated field based on a formula. You add transformations inside a Transform node. You can string together multiple transformations to manipulate data sequentially.

1. In the Transform node, select the date field in the Preview tab.
2. In the Transform toolbar, click the Bucket button (![Create bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_data_prep_bucket_icon.png)) to define the buckets.
3. Select whether to use absolute or relative dates.
    
    Absolute dates are defined dates on a calendar, like July 25, 2023. Relative dates are a time period in relation to the day the data is viewed, like last quarter, or next month.
4. Select ![Add bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_data_prep_recipe_add_filter_condition_button.png).
5. Enter a label for the first bucket.
    
    The first bucket is for the earliest date range. Each subsequent bucket must have a later date range than the previous bucket.
    
    ![The Define Range modal allows you to specify a bucket label and its range.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_bucket_dates_define_bucket.png)
6. Select the date range for this bucket.
7. Click **Add**.
8. To create another bucket with a later date range, click ![Add bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_data_prep_recipe_add_filter_condition_button.png) and specify the details.
9. To place null values into their own bucket, select **Bucket null values**.
10. Under Show Results In, select whether the new bucket values should appear in a new field and what should happen to the original field.
11. If you elect to create a field, set its label under Field Label.
12. Click **Apply** to add the transformation to the Transform node. The Preview tab shows the new bucket field.
13. To view the canvas, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_collapse.png)).
14. Click **Save**.

After you run the batch data transform, you can view the bucket assigned to each row in the bucket field.