Adding years to a date

Question

Hello,

Hoping someone can help.

I am looking for a workflow to add a value in years to a date field. One column is a number which is the value in years, the next column is a date. I am looking for the third column to output as a new date with the years added to the original date.

I have attached an image to show what I am looking to do.

Thanks,

Dan

JosephSerpis · Accepted Answer

Hi @DanMBrx you can use the Formula Datetimeadd to achieved the desired results you will need to get your dates into ISO format YYYY-MM-DD first. I've shared an example of how to use the formula.

jrlindem · Accepted Answer

@DanMBrx if you prefer to do your string-to-date and/or date-to-string conversions in a tool instead of formula, here is another approach.  Certainly, @JosephSerpis 's response is accurate and uses the least amount of tools, but if you prefer using the DateTime too, for example, here is how you can do that same thing:

Hope this helps, -Jay