There is no "DATE" field in SQL Server. All "DATE" fields will be should be transformed to "DATETIME".

How are you importing your VFP tables to SQL?

>So I was convinced by Jim Duffy to look at the SQL as main database for fox apps. So when I tried to import my current structures, my date fields all failed! Datetime fields however did not fail!
>
>Any quick fix Solution!
>
>Thanks Willie