Query for things happening this week

  • Thread starter Thread starter Laurie
  • Start date Start date
L

Laurie

Hello--

I have a table with a date that tells me when a student's suspension is
ending. How can I write a query that will tell me which suspensions are
ending this week and next week automatically, without me having to update the
dates in the query every week?

Thanks, as always, for the invaluable assistance of everyone on here.
 
Criteria --
Between DateAdd("d", -Weekday(Date())+1, Date()) AND DateAdd("d",
-Weekday(Date()) +14, Date())
 
Back
Top