>>Actually Michel, I think the '12-30-1899' date is for Foxpro. SQL Server's empty date is '1-1-1900'. > >The first one is from ODBC driver. The second one is SQL Server base date. All dates are stored as offsets from that date.
Yeah, thanks Sergey ... I posted that before I thought about it. But I was thinking more about it as I was making coffee and came back to change my reply to something about ODBC vs OleDB drivers. Your answer is probably more accurate though. <s>
