I have a 13 column browse. Each column represents a week. The weeks are consecutive.
The Browse looks like this:
Headers: 7/15/10-07/22/10-07/29/10-08/05/10-8/12/10-08/19/10-08/26/10-09/02/10-09/09/10-09/16/10-09/23/10-09/30/10
As you can see the 13 week columns span three calendar months. July, August and September. Each of the columns contains a value for the week indicated.
My need is to convert the 13 week information to calendar dates by the number of days in a month. As you know there are 13 week’s in the calendar quarter. July has 31 days, August has 31 days in September has 30 days.
Has anyone put together some code converting the 13 weeks of data into three calendar months. The biggest problem comes about when a week spans two months. Thus some of the values in that week need to go to the month before and some need to go to the month after.
For example the August 5-week needs to be split between July and August by days. And the September 2 week needs to be split between August and September by days.
The per day value is developed by taking the weeks value and dividing by 7.
All help will be appreciated.