>See
Re: VFP OleDb Provider Update Thread #
693808 Message #
696262.
>
>>I am accessing some VFP data with OPENROWSET and ultimately returning the result to dataset in C#.
>>My empty VFP dates are set to 12/30/1899. Does anyone know where this default resides or if I can get empty dates to be returned as null?
>>
>>Thanks,
I assume the new OLE-DB provider will support the new EVL() function that is in VFP 8.0. If so, you can just wrap all your dates with it in your selects...
SELECT evl(DateField,null), field2, ...
BOb