Jim, I capture and store the week and the month as I go. Then the summing of the data becomes easier.
If you use the same dates, you could be mixing days of the weeks, which could impact your sales results. This happens because 09/12 this year is a different day of the week than 09/12 of last year. At WM, the week starts on Saturday and ends on Friday. There are other definitions for the days of the week to include - Sun thru Sat, Mon thru Sun etc. You need to define what days make up your week. This has to be consistant. Do you set weeks up to represent calendar year or fiscal year. Generally there is 52 wks / year, however every 4th year you will have 53 wks. Now you will need to determine if you are going to measuring against the same week of the year or one week off. So you could be measuring week 53 against week 1 of the preivous year. I have setup a whole table to track all the date parameters. Just some things to consider... Gary ________________________________ From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, December 9, 2010 6:13:32 PM Subject: [RBASE-L] - Re: Week of the Year 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 > PPlease consider the environment before printing this e-mail >
