Date

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

Guest

Hey, I was would like my queries to only show those that date (in the field
with the dates of my records) was in the last week.

How would this be done in the criteria? Thanks.
 
rednikcam said:
Hey, I was would like my queries to only show those that date (in the
field
with the dates of my records) was in the last week.

How would this be done in the criteria? Thanks.
Click to expand...

Depends on how you're defining "in the last week". Do you mean within the
last 7 days? Or within the previous calendar week (Sunday to Saturday, for
example)?

Carl Rapson
 
As in the last 7 days, thanks.

Carl Rapson said:
Depends on how you're defining "in the last week". Do you mean within the
last 7 days? Or within the previous calendar week (Sunday to Saturday, for
example)?

Carl Rapson
Click to expand...
 
Use criteria like the following. to show all records with a date
between seven days ago and today.

Between Date() -6 and Date()

If your date field has a time component to it.

Field: DateField
Criteria: >= Date()-6 and < Date()+1





'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thank you very much this worked perfectly.

John Spencer said:
Use criteria like the following. to show all records with a date
between seven days ago and today.

Between Date() -6 and Date()

If your date field has a time component to it.

Field: DateField
Criteria: >= Date()-6 and < Date()+1





'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Back
Top