By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,688 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,688 IT Pros & Developers. It's quick & easy.

Invalid Operand for Operator: =

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.