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,