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
  In CRM Analytics, return the column date with the specified days or months added or removed.
• Date Difference
  In CRM Analytics, calculate the duration between two selected date columns as days, months, or years.
• Now
  In CRM Analytics, create a column in a Data Prep recipe that displays the current date and time in a specified format.