Query that returns entries of only the current week (or two)

  • Thread starter Thread starter Mewmew
  • Start date Start date
M

Mewmew

I have a database that keeps track of an entry's date. In the query I need to
create an expression that returns only entries with an entry date in the
current calander week (rather than within the past 7 days).

Thanks!
 
Try this:

SELECT *
FROM TableName
WHERE EntryDate Between
DateAdd("d", 1-DatePart("w",Date(),1), Date())
AND DateAdd("d", 7-DatePart("w",Date(),1), Date());
 
Back
Top