>Hello Cindy, the reason I convert them ( the dates ) to strings is for formatting reasons to add them to a ListView.
>
>
>If I query the DataSet the empty dates have a
>
>Using version 7 of VFPOLEDB
>DataType of "System.DateTime" with a value of "System.DBNull"
>
>Using version 9 of VFPOLEDB
>DataType of "System.DateTime" with a value of "12/30/1899"
>
>if you need any more info please let me know
Pete,
Are you sure you are testing these against same data? If datetime field accepts nulls (it should) then you would get System.DBNull. Otherwise 'empty' datetimes map to base date '12/30/1899'.
Cetin