>Thanks.
>
>I have been using the SQL Server driver and datetime and VarChar(max) seems to be OK. I use VFP SP2. The only issue I have is when I use DATE() arithmetic in my code it doesn't work. I have to change the code to DateTime().
Not necessarily so. You can create a schema on VFP side where these fields would map to date fields... I know we do it in cursoradapters (there's some code in the CA class which deals with the fields which are OK with the defaults, so only a list of exceptions is needed). ISTr that it was also possible with views and perhaps SPT cursors, but haven't played with those in almost ten years.
Anyway, when you have date fields on VFP side, it all works just like before.