>>>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.

I don' really know what's happening at the back end in this case, but our Sybase guys told us that it is default behavior with empty date fields.