>>Datetime. Other date formats... not so good, specially datetime2 which comes down as, IIRC, a memo.
>>
>
>There is nothing wrong with the MSSQL Datetime2 and Date data types as well as the old Datetime. It all depends on which SQL Server ODBC driver your FoxPro app uses.
>
>I used DateTime2 and Date and had no problems at all with either one of them.

Possible. I met datetime2 on a remote machine only, where I didn't have a choice. It's still quite a rare beast out in the field - among few dozen databases from others that I saw in the last few years, there was only this one case. And even then it served no purpose - it contained just dates, no times. Whoever used it didn't quite RTFM.