Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

syntax for querying between dates with ADO

275224Apr 14 2003 — edited Apr 14 2003
Hello,

I am connecting to Oracle tables using ADO in Microsoft Access. I am not familiar with Oracle Sql. I am trying to execute the following query string but am not retrieving and records:

strSql = "SELECT COUNT(*) " _
& "FROM CCC2.CASE_EPRP WHERE CALL_DATE >= '1/1/2002' " _
& "AND CALL_DATE <= '2/1/2002'"

I can retrieve a record count if I only have the first date, but if I use the date range above the query returns zero records even though there are records for that date range. Could someone explain the correct way to write this query?

Thanks,
Rich
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2003
Added on Apr 14 2003
#odbc, #windows-and-net
2 comments
578 views