Jim, The answer is easy. Subtract 52*7 or 364 from your start and end dates.
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, May 10, 2010 4:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - 52 weeks apart I want to compare weekly totals one year apart. But I want to make sure the comparison is 52 weeks ago. In other words, I want to compare Sun - Sat this year with Sun - Sat 52 weeks ago. Right now I am using the two dates this year - 365 days for each date. Jim
