all records for last "monday"

[papasmurfuo9]

hi in my query im doing the following to pull all records for the previous week

Total Completed: Sum(IIf([Date Completed] Between Date()-(6+Weekday(Date(),2)) And Date()-Weekday(Date(),2),1,0))


what i need now, is one for just Last monday, last tuesday last wednesday last thursday last friday

can anyone get me started with just records for last monday?

thanks in advance

 

[namliam]

Last monday is:
date() - weekday(date(),2)+ 1

or if you prefer
date() - weekday(date(),3)

 

[papasmurfuo9]

cheers pal -

sorry just to confirm, thats last monday of the previous week?

 

[namliam]

date() - weekday(date(),2)+ 1 = 16-feb-2015
date() - weekday(date(),2)+ 1 - 7 = 09-feb-2015

Or

date() - weekday(date(),3) = 16-feb-2015
date() - weekday(date(),3) - 7 = 09-feb-2015

 

[papasmurfuo9]

cheers dude

 

[namliam]

Date()-(6+Weekday(Date(),2)) from your formula btw is also 09-feb-2015

Different ways of doing the same calculation