Date and Time Transformations: Calculate on Date Fields

In Salesforce Data Pipelines, 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
  In Salesforce Data Pipelines, return the column date with the specified days or months added or removed.
• Date Difference
  In Salesforce Data Pipelines, calculate the duration between two selected date columns as days, months, or years.
• Now
  In Salesforce Data Pipelines, create a column in a Data Prep recipe that displays the current date and time in a specified format.
• Guidelines for Formatting Dates
  Review these guidelines when working with dates.