I hope someone can help with this very simple query that I seem to be struggling with.

In the Sales Order section I have 2 fields - 'Due Date' which is a selectable date and 'Contract Renewal' which I want to automatically add 1 year to from the 'Contract Signed' date.

This is the formula I have so far...

Adddate( Newdate( ${SalesOrders.Due Date}) ,1 ,'YEAR')

If anyone can help that would be much appreciated.

Many thanks,

Nathan