• 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