Invalid Operand for Operator: =

[jayj0nes]

I'm querying a Mas90 db via ADO in Access.
The following SQL gives me the error "Invalid Operand for Operator: ="
"SELECT * from GL_DetailPosting where PostingDate >= '#01/01/2004#'"

These other queries work just fine, and they return valid data in the
PostingDate field:
"SELECT * from GL_DetailPosting"
"SELECT * from GL_DetailPosting order by PostingDate DESC"

Any ideas where I am going wrong? I've tried just about every syntax I
could think of for the date, but no luck.

[Rick Brandt]

<ja******@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

I'm querying a Mas90 db via ADO in Access.
The following SQL gives me the error "Invalid Operand for Operator: ="
"SELECT * from GL_DetailPosting where PostingDate >= '#01/01/2004#'"

These other queries work just fine, and they return valid data in the
PostingDate field:
"SELECT * from GL_DetailPosting"
"SELECT * from GL_DetailPosting order by PostingDate DESC"

Any ideas where I am going wrong? I've tried just about every syntax I
could think of for the date, but no luck.

Dates are delimited with #. You have both # and single quotes. Lose the
latter.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com