rwpetrie
11-15-2001, 06:52 AM
What expression do I type in my criteria so that it will only show the results with the date field within the last week?
|
View Full Version : Date Criteria rwpetrie 11-15-2001, 06:52 AM What expression do I type in my criteria so that it will only show the results with the date field within the last week? Graham T 11-15-2001, 07:21 AM Try using >=(Now()-7) This should return all records with dates within the last 7 days. HTH rwpetrie 11-15-2001, 07:57 AM Thank you! It works great! |