I think this is cause the VFPOLEDB return a vaue of 0 rather then NULL to support empty dates in VFP.

Returning 0 causes .Net to store the beginning of time or "12/31/1899 12:00 00000" where NET actually store System.DbNull.value as an empty date.

In my OleDbDataAdapter i will use a string like this to fill NULL data values into my dataset.

"IIF(EMPTY( dCreated ), null, dCreated ) as DateCreated"

I have used it on VFP6,7,8 using the VFPOLEDB 8 driver.

- jim


>I retrieve a row from a VFP table, as datareader, where a date field has not entry (in VFP). But when I look at it in ASP.NET the date is there and it is 12/30/1899. I know I didn't enter any data in 1899 <g>. Who did?
>
>TIA.