Add or Subtract Days or Months

Add or Subtract Days or Months

1. In a Transform node of a Data Prep recipe, select one date column in the Preview tab.
2. Select the Formula button () in the Transform toolbar.
3. Select Add or Subtract Days or Months.
4. Configure the transformation.
   
   1. Start Date Column is automatically filled with the date column you previously chose. Cancel and restart to choose a different Start Date.
   2. Choose Days or Months to add or subtract.
   3. Select the number to add or subtract with the plus and minus buttons.
   4. Choose the date format of the output column.
5. Optionally, change the label of the column that stores the result data in the Column Label field.
6. Click Apply to add the transformation to the Transform node.

   The Preview tab shows the new calculated date column.

   
7. To view the Graph area, click the Collapse button ().
8. Save the recipe.