Date query - link w/Oracle

G

Guest

I just upgraded from Access 97 to Access 2002. I have tables linked with
Oracle 8. In the old version of Access, this query worked:

StartDate: >=Date() And <=Date()+1.625

EndDate: >=Date()+0.625 And <=Date()+1

In the new version I get Oracle Error 01847 stating the day of the month
must be between 1 and last day of month.

Can anyone help?

Thanks!
Mary
 
G

Guest

Anytime I see a problem with the Date() function, I have a knee-jerk reaction
about references. Go to the following web page for information on checking
referencens:
http://www.mvps.org/access/bugs/bugs0001.htm

What are the regional settings for your computer? If it's anything other
than English (United States) that might be giving you trouble. Could also be
a problems with the NLS (National Language Set) in the Oracle database but I
doubt it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format DATETIME to Date in query on linked table 4
Access pass-through query to Oracle 10g stored procedure - results 1
Access 2000 Query very slow compared to SQL Query Analyzer 5
Append Query - return data for each day within a date range 2
Query using date range entered by user 2
Formatting date gives bad results in query 2
Calculating Rolling Usage 1
Oracle criteria problem 1

Top