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

We had the same problem with Sybase, it does the same thing. The solution was allow .NULL. value in the date fields, and replace with .NULL. when it is empty. It also requires additional checks in code
(for ISNULL(datefield) )

Nick