---
schema_version: "1"
id: b4d4122165ede3f3410cb84d9546884fbd19ef4cfe946d88b19de6e2a9d6eed0
title: "Date and Time Transformations: Calculate on Date Fields"
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_date_and_time.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_date_and_time.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9ad6e1d1dc1a582aa0419416b6d18ad725e541f0c1664a0055424ca8639da1f2
description: Date fields are key to understanding trends over time or keeping teams aware of upcoming milestones and deadlines. To calculate based on dates or make them more helpful to your analysis, use date and time transformations. Insert a column with the current date and time in a specified format with the Now option. Calculate the duration between two selected date columns as days, months, or years using Date Difference. And add or subtract days or months from a date column with the Add or Subtract Days or Months function.
products:
  - Data 360
release: "264"
---
# Date and Time Transformations: Calculate on Date Fields

Date fields are key to understanding trends over time or keeping teams aware of upcoming milestones and deadlines. To calculate based on dates or make them more helpful to your analysis, use date and time transformations. Insert a column with the current date and time in a specified format with the Now option. Calculate the duration between two selected date columns as days, months, or years using Date Difference. And add or subtract days or months from a date column with the Add or Subtract Days or Months function.

- **[Add or Subtract Days or Months](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_add_subtract_time.htm&release=264.0.0&type=5)**  
    Return the column date with the specified days or months added or removed.
- **[Date Difference](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_duration_between_dates.htm&release=264.0.0&type=5)**  
    Calculate the duration between two selected date columns as days, months, or years.
- **[Now](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_now.htm&release=264.0.0&type=5)**  
    Create a column that displays the current date and time in a specified format. This transformation works without interacting with any other columns.