>>
>From a data set, if I have a record where a datetime field is empty, displaying this field with .ToString will give "30/12/1899 01:00:00". Is this normal?<>>
>>No. Where is your data coming from?
>
>The data comes from a VFP table. Basically, some fields have empty values. We use OleDbDataAdapter to extract specific records from there. This is when we end up with such weird conversions.
Michel,
I think it's a result of OleDb specification:( ODBC behaves the same way. Set your datetime field to accept nulls and replace empty values with null or during getting data from VFP convert it to string in your SQL rather than using ToString() later.
Cetin