>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
I don't think the OLEDB provider for ODBC sources has a concept of empty dates. (It's a pretty strange concept if you think about it). I think you're in for some manual work.
Erik Moore
Clientelligence