Date expression used in criteria field

[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?

 

[Wayne-I-M]

=Date()-14

=Date()+14

 

[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?

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.