Re: Stupid Monday Problem

Hi.

Dates should be quoted like '04/16/00'
What you're trying to do is to calculate
an integer of value 04/16/00 (which, if
the parser would let it through, would
even generate a division by zero error.)

Regards,
Patrik Kudo

Kenn Thompson wrote:
> 
> 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'tseem 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
toretype this query using an explicit cast