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
  Return the column date with the specified days or months added or removed.
• Date Difference
  Calculate the duration between two selected date columns as days, months, or years.
• Now
  Create a column that displays the current date and time in a specified format. This transformation works without interacting with any other columns.