Date expression used in criteria field

B

boz

I assumed when you enter the expression Date()+14 would give you 2 weeks of
information from the current date, but when I entered Date()-14 it gave me
more information than the 1st expression, can anyone explain this to me?
 
J

John W. Vinson/MVP

I assumed when you enter the expression Date()+14 would give you 2 weeks of
information from the current date, but when I entered Date()-14 it gave me
more information than the 1st expression, can anyone explain this to me?
Click to expand...

Depends on where you enter it and what is in the data - neither of
which we can see.

A criterion of

Date()+14

will retrieve records with a date value of August 11 (if run today).
Records before or after that date will not be returned; records with a
time portion - such as #08/11/2008 11:35:21# - will not be returned.

Step back a bit. Describe your data, where and how you're specifying
the criterion, and what result you wish to obtain.
 
Top