Re: Weeks Numbers

["Hagster" <webforumsuser@xxxxxxxxxxxxxx>]

Thanks Dan, obviously its such a simple solution, why do things like this just 
evade me :)

 Any way being a little lazy here I have set up my SQL to do as you surgested, 
but have a question with weeks that have two months as this one, how does the 
MS Server denote which month to put the week into?
 is it the month that the week starts in?

 I will go work it out tomorrow just wondered if you new of top of your head.

 ***** new select  below********************

 SELECT MONTH(planned.planddate) AS planmonth, DATEPART(ww, PLANNED.planddate) 
AS planweek,