If I try sql such as ALTER TABLE `aa_orders` CHANGE `datedelivery` `datedelivery` DATE NULL DEFAULT 'NOW()' I get the same message Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Help with default date field to today's date ...