M
Moochie169
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.
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.