I guess the answer could be using phpmyadmin with something like NOW() or CURRENT_DATE in the default box when setting up the field - but i get error messages saying this is an invalid default value If I try sql such as ALTER TABLE `aa_orders` CHANGE `datedelivery` `datedelivery` ...