date parameter problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a report that pulls data from a query. In the query I want to set up a parameter that the user will put in last monday's date and the report will print the data for that monday plus the rest of the week until sunday, essentially 7 days. I did have >Date()-7 that I used when I printed the report every monday. Now if I print it on tuesday instead it will give me the dates for last tuesday thru monday, again 7 days but the wrong days.
How can I create this so I can get the last 7 days or just Monday thru Sunday of the previous week.

Thanks,

John
 
Try:
Date() - Weekday(Date(), 2) + 1
Click to expand...

The 2 specifies Monday should be counted as the first day of the week.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

John Daily said:
I am trying to create a report that pulls data from a query. In the query
Click to expand...
I want to set up a parameter that the user will put in last monday's date
and the report will print the data for that monday plus the rest of the week
until sunday, essentially 7 days. I did have >Date()-7 that I used when I
printed the report every monday. Now if I print it on tuesday instead it
will give me the dates for last tuesday thru monday, again 7 days but the
wrong days.
 
Back
Top