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

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!
 
K

Ken Snell \(MVP\)

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());
 
R

raskew via AccessMonster.com

try: ...between date() - weekday(date) + 1 AND date() + 7 - weekday(date)


Bob
 
Top