[Inger]

UPDATE randomdate SET randomdate= DATE_SUB(CURDATE(),INTERVAL RAND()*365 DAY);