>I don't see how you can use the SQL provider with VFP tables. That wouldn't work at all and is not what I was saying. Since this question was in the SQL Server forum, I thought we were talking specifically about accessing data on SQL Server.

When I will use the SQL provider to access SQL Server tables, will I end up with 1-1-1900? My framework is set up to support OleDB, SQL and ODBC providers. If this fact is true than I will rely on oApp.nSQLMode to detect how to verify for this empty date.