This content has been marked as final. Show 4 replies
The simplest way is to select the datepart that gives you the month as part of your query. Before doing so, decide what to do about weeks that have two months, this week for example.
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,
When I wonder about stuff like that, I code it and try it.
I know :), thought it was a little cheeky asking.
Any how thanks for the replys all working and done now.