Received: from 10.0.0.4 ([208.245.233.8]) by hub.org (8.9.3/8.9.3) with SMTP id LAA10295 for ; Mon, 17 Apr 2000 11:30:11 -0400 (EDT) (envelope-from KThompson@adestagroup.com) Received: from MFSNTOMAM_DOMAIN-Message_Server by 10.0.0.4 with Novell_GroupWise; Mon, 17 Apr 2000 10:29:24 -0500 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Mon, 17 Apr 2000 10:28:47 -0500 From: "Kenn Thompson" To: Subject: Stupid Monday Problem Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id LAA12153 X-Archive-Number: 200004/165 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