Hi
We have a contract table that has a contract run function using start/end date field.
We have another function that duplicates that record, i am yet to find a way to add 12 months to this field
For example we have 01/02/2025 to 31/01/2026, i would like to duplicate this within the above function but with the additional 12 months added.
Any suggestions please?
Hi @AndrewClar42169 
Are you using Classic or Next Gen? 
I don’t think its possibe using Extraction and Text Formulas as there is no way to map the start and end dates back to the complex date field. Personally this is the sort of thing I would do in Make. I’d use a snippet of JavaScript to send the recordid to a webhook. Extract the dates and use Makes “addYears” function using the ISO timestamp value, to avoid any issues with UK / USA date formatting. Then send a 200 response back to refresh the view.
I’m not sure if this is possible in Flows but its pretty simple to setup if you are still using Classic and Make.
Hi Carl, thanks for the reply, still have access to the classic developer.
I’ll see what I can do in Make. I’ll need to read the old contract then update the new contracts field that I leave blank.
If you need a hand let me know 