I am querying an Oracle (8 or 9) Database from MS 2003 front end. I get an error message [Oracle][ODBC] Invalid date/time format. (#0)
I think this is because there are null fields in the Oracle date field. I have tried using a function to test for nulls and assign an arbitrary date (the "null" date fields in Oracle are from the initial data load and I don't need results from that time frame). Nothing seems to work. Please help. I mark this "urgent" because I am under a crushing time deadline to fix this.