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

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

 

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

 

[raskew via AccessMonster.com]

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


Bob