Automating a report - Need to manipulate from date.

I run a weekly report from Sunday-Saturday for sales. I want to automate it so when I run it say on Saturday evening it picks the from Date of last Sunday. Is there anyway to take the current WORKDATE (10/16/10) and go back to the previous Sunday (10/10/10)??

i.e. 10/10/10 thru 10/16/10 without entering any dates manually and have it work every week of the year.

Thanks in advance,


Hi Greg,

You can use the CALCDATE function for this and applying a date formula to your current date, ex. CW-1W (Current week minus 1 week).

Let me give that a try Erik.