Hello,
I would guess it is an issue with the format that the data is stored in, in the old column.
Is it always the same format e.g. mm/dd/yyyy? Can you post a sample of the data in the old column?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group