Ok- here's the problem ( too little coffee?)...
This query runs under Access. I of course change a bit of the SQL ( removed the '#' and have played with quotes), but can't seem to get it to run.
What the #%$^& am I doing wrong here?
Kenn
SELECT oid FROM file_header WHERE expire_date < 04/16/00
ADODB.Recordset.1 error '80004005'
Error while executing the query; ERROR: Unable to identify an operator '<' for types 'date' and 'int4' You will have to retype this query using an explicit cast