I made some tests, and yes but you have to use the latest ODBC driver that comes with SQL 2008, otherwise it will put the date as character field in the view or CA. Use SQL Native Client 10.0 and it should work.
Luis
>>I'm hoping that VFP9 recognizes the new DATE datatype in SQL2008. I don't have SQL2008 installed so I cannot test it myself. Does anyone know?
>
>I've gotten no response at all to this question. Does this mean that no one is using SQL2008 yet?
I never forget a face, but in your case I will make an exception :-)