>>I have a view of a MS SQL Server table. The view contains three datetime fields that I have defined in the view properties to be Date fields. When I modify a record or add a new record, and I leave these fields blank, VFP saves the date 01/01/1900 in these fields! I want them to remain empty!
>
>Generally speaking it is not VFP, it is MS SQL Server behaviour.

Hi Nick,

Thanks for the reply! I guess I'll have to add the additional code. However, I don't see how this can be a MS SQL Server problem. The problem does not occur when I use MS Query.

Jeff