How-to | Increment a date to compute a deadline#

In addition to interactive date filtering, Dataiku 9 introduced additional date processing features, such as the Increment date processor, which allows you to compute future (or past) dates based on a user-defined interval.

This processor can be particularly useful for calculating rolling deadlines. Let’s imagine that an airline company wants to use the current flight reviews dataset to attribute a gift voucher to everyone who has submitted a review, and that the voucher would be valid for one year from the date of submission.

As the dates of submission vary for each review, we could calculate this by using a formula, but now it’s even easier to do it with the Increment date processor.

  1. Click + Add a New Step and select Dates > Increment date with a specific value.

  2. In the Column field of the recipe step, select the date column that you want to increment on.

  3. From the Date part dropdown, select the date part that you want to increment on (in this example, we choose Year).

  4. In the Increment field, set the length of the period (in this example, we set it to 1 Year). It is also possible to enter a negative value, if you want to increment a period in the past.

  5. In the Output column field, type the name of the column you want to store the increment date value in (or leave empty to increment in-place).

../../_images/increment-date.png

In the example above, we choose to store the output in a new column named voucher_expiry_date, which now appears next to the date column and contains, for each row, a timestamp that is exactly one year after the date stored in the date column.