For ODBC, there is no concept of a blank date. I'm not sure why that is but blank dates in a VFP table will be stored as 12/30/1899 and in SQL server as 01/1/1900. The only way that I know to represent a blank date in a date or datetime field using ODBC, as Borislav indicated, is to set the field to allow nulls and set it to null.

>Hello everyone, How can I assign a blank record date to a field date datatype if im using a sqlremoteview and my based table is still the native DBF.
>
>Replace datefiled with {}
>
>This line wont work anymore i get an err msg of Data Type mismatch.
>
>I hope someone can help me on this.
>
>Thanks and regards,
>Marlon Estrelon