>i am using a SQL Server database.
>
>i have a view that reformats a sql - datetime datatype to a vfp date datatype.
>
>the default value in sql is null. when i save a record with an empty date it is automatically saved as 01/01/1900.
>
>is their a way to get around this problem. it may be something with ODBC, but we are not sure.
>
>tia
>frank

Frank,

I personally think it's something with ODBC. We use Crystal Reports which accesses our VFP data through the ODBC driver. If a blank date field is encountered, it gets returned as a date value of 12/30/1899.

Laterness,
Jon