Date Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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?
 
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
..
 
Back
Top