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.
-
Click + Add a New Step and select Dates > Increment date with a specific value .
-
In the Column field of the recipe step, select the date column that you want to increment on.
-
From the Date part dropdown, select the date part that you want to increment on (in this example, we choose Year ).
-
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.
-
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).

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.