I have used this to add one year to the now date
<?php echo (date("Y-m-d h:n:s", strtotime("+1 year"))); ?>
Hi Paul, did you get this sorted? I have done this via sql recordset before but not in php?
In recordset try
tblPaulDateColumn,DATE_ADD(tblPaulDateColumn, INTERVAL 1 YEAR) AS FieldAliasName,