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
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
all records for last "monday"
0 commentaires:
Enregistrer un commentaire