Hi all, Any ideas why this works in MySQL 5.0.18 and not in 3.23.53-log? "SELECT StartDate + INTERVAL 1 MONTH from petition;" The manual implies* that this completely possible in MySQL 3.23.x... http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_date-add Weird thing is that MySQL 3.23 lets me run the query like this: "SELECT CURRENT_DATE + INTERVAL 1 MONTH as one_month_later;" But this fails: "SELECT CURRENT_DATE + INTERVAL 1 MONTH as one_month_later from petition;" Any ideas welcomed - I'm quickly running out :) Paul