Minus date by 4 months, and plus 1

Imran_Saiful_sc

Hi dataiku community, can you help me with this problem

I have a date column where it is always a month end. for example 2025-11-30 or 2026-01-31

and now i want to minus that date by 4 months, and add 1 day to it.

so if the date is 2025-11-30 it will be 2025-08-01

if the date is 2026-01-31 it will be 2025-10-01

does anyone have solutions for this? thank you.

Operating system used: Windows

Operating system used: Windows

Turribeach

Hi, the solution will depend on what data type the column is on. If it is a proper date you can use a Prepare recipe and use the Formula language function inc() to add or remove units of time:

https://knowledge.dataiku.com/latest/data-preparation/formulas/concept-formulas.html

https://doc.dataiku.com/dss/latest/formula/index.html#date-functions

If it is not a date you will first need to use asDateOnly() to convert your string to a date. Then do your date changes and finally convert back to your using datePart().