On the same line of questioning how do I go back to a specific week from a previous year.
I find first of all this years week as you mentioned to Victor. I then want to go back to the same week of the previous year. But on top of that, I want to total the sales for all the days of the previous year on the same week. Right now I just go be same dates. I want the same week. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, December 09, 2010 6:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Week of the Year SET VAR vIWOY = (IWOY(.#DATE)) -----Original Message----- From: "Victor Timmons" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 9 Dec 2010 16:05:11 -0800 Subject: [RBASE-L] - Week of the Year Does anyone have a formula that can figure out what week of the year the current date is in. 12/09/2010 is in week 49 Victor Timmons Tiz's Door Sales, Inc Visit us at www.tizdoors.com <http://www.tizdoors.com/> P Please consider the environment before printing this e-mail
