Weekly Date Range in Query

  • Thread starter Thread starter Natalie
  • Start date Start date
N

Natalie

I'm sure this is simple, but how can I pull a current
week's date range within a query? I have been using the as
of date, but want to simply the report and not have to
enter the date criteria. Any help is appreciated.
 
Try this:

If "current week" always means the week you're in at run
time, then try

weekstartday= now()-weekday(now())+1
weekendday= now()+7-weekday(now())
Format output as needed; the now() function returns clock
time as well as the date.

If you need "current week" as of some [date] in a record,
then substitute that [date] for the now() function.

The +1 and +7 works for Sunday=first day of week. If your
week starts on another day, adjust the constants
appropriately.
 
Back
Top