DATE/TIME MATH ISSUE!!!!

M

Mike S. S.

I have a query that goes against a table and filters rows by applying
criteria to a date field, an example being:

<=#11/30/2008# And >=#11/30/2008#-7

I expected to get all rows where the date field value was between 11/30/08
and 11/24/08, inclusive. However what I get are rows where the dates are
between 11/29/08 and 11/23/08, inclusive. I can understand that I should
have -6 instead of -7, but I don't understand why I am not getting back rows
where the date = 11/30/08. It returns the rows I want when the formula is:

<=#11/30/2008#+1 And >=#11/30/2008#-6

Can someone explain this PLEASE????? THANKS!!!!!!!!
 

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

Top