>I messed up. I just checked and I misunderstood originally, it is NOT a datetime field. It is:
>
>PK, varchar(14), not null
>
>
May be you need to first CONVERT this to a DATETIME then? Just guessing, don't have SQL Server here right now.
If it's not broken, fix it until it is.
My Blog