---
schema_version: "1"
id: 72f574affe084372ec9c243bc493c6fb5a2f219a94f5212f10bdd7ba87cc9b2f
title: Date Difference
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_duration_between_dates.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_duration_between_dates.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 33ce46418aeaca29873fcf1ed018f59ea01c4042f527647ec44420849456e529
description: Calculate the duration between two selected date columns as days, months, or years.
products:
  - Data 360
release: "264"
---
# Date Difference

Calculate the duration between two selected date columns as days, months, or years.

1. In a Transform node, select one date column in the Preview tab.
2. Select the **Formula** button (![Formula 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_recipe_transformation_formula.png)) in the Transform toolbar.
3. Select **Date Difference**.
4. Configure the transformation.
    
    ![The Duration menu appears when you select Date Difference.](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_recipe_duration.png)
    
    1. The start date is automatically filled with the date column you previously chose. To choose a different start date, cancel and restart.
    2. The end date is the value used to calculate the duration from the start date. Choose a date column from your data or the **Now** option to use the current date and time.
    3. Select whether to return duration as days, months, or years. Days are rounded up to the nearest value, while months and years include the selected number of decimal places.
5. Optionally, change the label of the column that stores the result in the Column Label field.
6. To add the transformation to the Transform node, click **Apply**. The Preview tab shows the new Now column.
    
    ![Preview shows the new Duration column.](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_duration_outcome.png)
7. To view the canvas area, 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).

After you run the batch data transform, you can view the calculated duration. The Now option uses the date and time when the batch data transform last ran, based on the UTC timezone.