Date

R

rednikcam

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.
 
C

Carl Rapson

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
 
R

rednikcam

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...
 
J

John Spencer

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
'====================================================
 
R

rednikcam

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...
 
Top