When you browse the view does the date field show NULL, Blank date or {01/01/1990}?

If it is showing the NULLS or an empty value, you may find that the date input mask is your problem. Just a SWAG, but try removing the input mask from the control that displays the date. The input mask may be changing the NULL to a blank date as you scroll through the view with a blank date being sent back to SQL Server. In ODBC for SQL Server, blank dates translate to 01/01/1990, In VFP database, they translate to 12/30/1899.

Hope this helps