Are you checking that what the user enters is a valid date before updating? SQL Server doesn't have a concept of "empty" date like in VFP. It must have a valid date or be null (if allowed) so it might be that you're trying to insert an "empty" date instead of a null.

>John;
>
>I found a work around and will use it until something better shows up. I check for the length of the value of the textbox and if it is greater than zero, I allow the update. More code to maintain but life must go on and all that. In VFP, I would just format the variable and that would be that.
>
>Tom