Originally Posted by Kaylum

hey there

he wrote that he wasn't fully awake ;)

there is some garbage in the sql, (FROM and FOR).. the sql should read:

UPDATE b1datefix SET date2 = CONCAT(SUBSTRING(date,-4),'-',SUBSTRING(date,1,2),'-',SUBSTRING(date, -7,2));

let us know how it goes ;)

peace