yes I managed to do it like you said Gary. Sorry not sure what you mean by your last sentance Jason.
The php code i entered into the update record behaviour date column is
<?php echo $row_Recordset2['DATE_ADD(renewal_date,INTERVAL 1 YEAR)']; ?>
which does indeed uodate the date by 1 year
thanks