>>Actually Michel, I think the '12-30-1899' date is for Foxpro. SQL Server's empty date is '1-1-1900'. > >I am using the OleDb provider from .NET to access VFP tables. It returns that. Are you saying that if I use the SQL provider that I will end up with 1-1-1900?<
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.