Monday-Sunday Date Range

[Guest]

Hi,

I'm not very strong with Date functions especially calculating dates. But I
have a report that I would like to automatically run every Monday morning at
130AM. Many of my queries involved a date range which is the previous Monday
to Sunday. I was wondering if someone can help me out so I can finally sleep
early on Sundays.

I've look around and cannot find what I need. Here's what I have so far.

BeginDate: DateAdd("d",-7,Now())
EndDate: DateAdd("d",-1,Now())

My date criteria is
Between DateAdd("d",-7,Now()) And DateAdd("d",-1,Now())

I know this is not the most efficient way and that is also taking in the
time into consideration. But I'm running out of ideas.

Thanks for your help.

 

[[MVP] S.Clark]

You've overthought the play, as

Between Now()-1 and Now()-7 would do.

As far as scheduling the query to run every sunday at 1:30am, Total Visual
Agent can help.

http://www.fmsinc.com/products/agent/index.html

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Guest]

Thanks for responding so quickly. But when I compare old query with a new
query with your logic. The numbers do not match. Is it because of the
timestamp? If so, how would I have it ignore the timestamp?

Thanks,