>
>Notice for DATETIME datatype on MSSQL - mininal value is 1753-01-01.
>If values of datetime on VFP side is less then 1753-01-01, then datatype on MSSQL must be DATE or DATETIME2.
>
>MartinaJ

Oh yes good point. I didn't have a need for times before 1996 ever so I always forget that. Speaking of that, I would suggest absolutely setting the DateTime(2), Date to accept NULL.