---
schema_version: "1"
id: fe0eda6f8b65bfa259ee9a77d9525babe3b899f478443ebc356f8c87b30500ac
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/analytics/264-0-0/bi_integrate_recipe_transformation_date_and_time.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_date_and_time.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1adcb6832e491c62170a17def14d5ecfa84c7c8f856b39032577acc8fd4b829d
description: In CRM Analytics, your date fields are key to understanding trends over time or keeping teams aware of upcoming milestones and deadlines. Use the Date and Time transformations to calculate based on dates or make them more helpful to your analysis. With the Now option, you can insert a column with the current date and time in a specified format. Use Date Difference to calculate the duration between two selected date columns as days, months, or years. And use the Add or Subtract Days or Months function to add or subtract days or months from a date column.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Date and Time Transformations: Calculate on Date Fields

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

- **[Add or Subtract Days or Months](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_add_subtract_time.htm&release=264.0.0&type=5)**  
    In CRM Analytics, return the column date with the specified days or months added or removed.
- **[Date Difference](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_duration_between_dates.htm&release=264.0.0&type=5)**  
    In CRM Analytics, calculate the duration between two selected date columns as days, months, or years.
- **[Now](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_now.htm&release=264.0.0&type=5)**  
    In CRM Analytics, create a column in a Data Prep recipe that displays the current date and time in a specified format.