Weekly Reports

[Tim DuBois]

I'm having massive difficulty trying to print weekly reports in the following way: I have a report generated for a month, May for aregument sake. I want the data in the report broken up into 4/5 weeks, not simply flowing though the month. In other words: Week 1: data data data Week 2: data data data Week 3: data data data Week 4: data data data Each set of data has a full DateTime variable with it. I've managed to get a week number from each date - but they're in relation to the year, not the month. Any ideas?

[KSEI]

I think you can just substract the week number u got, with the last month week number. This is a simple example (mm/dd/yy is the date format): select convert(numeric(3,0), datename(ww, '02/24/2004')) - convert(numeric(3,0), datename(ww, '01/31/2004')) The query will give u the week number relate to the month for 24th Feb 2004. Hope this can help u, :)