>Hi
>When i connect to a SQL Server DB, either with the Database Explorer or through sqlstringconnect, all the DATE fields figure in VFP as numbers.
>For instance, March 18, 2005 comes as 9051840
>What did i do wrong?
>
>Thanks
>Jaime

What driver you're using to get them from SQL Server (e.g. show your connection string).

I believe some drivers do not recognize new DATE fields at all.

Would you be able to use datetime column instead or you must use DATE?

Can you search VFP forum for that problem (it was discussed in the past but I don't recall exact solution)?