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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mewmew - 18 Apr 2008 02:50 GMT

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!

Reply to this Message

Ken Snell (MVP) - 18 Apr 2008 03:26 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

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

Reply to this Message

raskew - 18 Apr 2008 04:40 GMT

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

Bob

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

Reply to this Message