Creating a recordset for previous week

  • Thread starter Thread starter Alan Fisher
  • Start date Start date
A

Alan Fisher

I am trying to create a button that allows me to open
records where the date field has dates from last week. I
am going in the direction of using the datepart funtion to
show me the current week but I can't figure out how to go
from there to diplaying week - 1 in a Where clause to
open the form. Any ideas?

Thanks to those that helped me figure out I needed quotes
to make the datepart function work. I can't belive I
forgot them.
 
First day of Last week:
=DateDiff("d",Weekday(Date()-1,1),Date())-7
Last day of Last week:
=DateDiff("d",Weekday(Date()-1,1),Date())-1
 
Back
Top