Add or Subtract Days or Months

Return the column date with the specified days or months added or removed.

1. In a Transform node, 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. The Start Date Column is automatically filled with the date column you previously chose. To choose a different start date, cancel and restart.
   2. To add or subtract, choose Days or Months.
   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. To add the transformation to the Transform node, click Apply. The Preview tab shows the new calculated date column.
   
7. To view the canvas area, click the Collapse button ().