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!!!!!!!!
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!!!!!!!!