trying to figure out if there is a way in crystal to pull open qty for a week and the week needs to start on a Friday so for example if promise date is 1/15/12 it would populate qyt order in week 3 of january 2012 (weeks defined below starting on a Friday, year end is 12/31/12 )
Week 1 in january 2012 is 12/30/11 - 1/5/12
Week 2 in january 2012 is 1/6/12 - 1/12/12
Week 3 in january 2012 is 1/13/12 - 1/19/12
Week 4 in january 2012 is 1/20/12 - 1/26/12
Week 5 in january 2012 is 1/27/12 - 2/2/12
