Calculate Date

Hi, I hope you are doing well,

I need to calculate a future date with a date base and quantity of moth. For example:
I have a data with 31/01/2020 and I need to add 72 months more and the final result need to be 31/01/2026.
KNIME Q.xlsx (9.8 KB)

Attached you can find son examples; I really appreciate if you can help me!

Hi @SergioSB , for this you can use the Date&Time Shift node.

Using your sample data, you can configure it like this:

After that you can use Column Renamer to rename the newly created Asset Data (Final Date) column which you can see here will contain the values as you have given in the example:


Thanks, I really appreciate it

1 Like