Hi
I'm using ADO from an ASP page to query a FoxPro table using the VFP ODBC driver. One of the fields in the query is a date field - 'date_deliv'. When this field is empty in the Fox table, the ADO recordset contains "12:00:00 AM". Apparently ADO is treating the field as a DateTime field. I checked the ADO data type for the field, and it is a dbf date type field. Is there any way to have ADO return empty date fields without inserting the time, or do I have to check the field for a value of "12:00:00 AM" to determine if I have an empty date?

TIA
Bill Sabo