Date Calculation

[Guest]

I need to query all records that have a date from today back through the
past 30 days (from a date field in a table). I tried <=Date() - 30 with no
success. Other ideas?
Thanks!

 

[Guest]

=Date() - 30

 

[Guest]

Daa....you caught me in a brain freeze. Clearly I had a typo! Thank you!

 

[Guest]

Karl I am trying to pull data very simialr to this however I am trying to see
only items that are less than 45 days old. I have tried this <Date() - 45 but
it is still including recent dates not just those older than 45 days. Can you
give me some help with this?

 

[John Spencer]

If you want to see items that are between 45 days old and 0 days old

Field: SomeDateField
Criteria: Between Date()-45 and Date

or if none of the dates are in the future.

Field: SomeDateField
Criteria: >=Date()-45

IF you are trying to get records that are older than 45 days, you criteria
should work (IF you are applying the criteria against a DATETIME field).
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..