DatePart has two optional parameters when you use 'w' (weekday) or 'ww' (week). The first is the first day of the week. You can set it to anything, I have a client that Friday is the first day of the week. The second optional parameter is the first week of the year. It can be set to three different things, one being the week that the 1st is in, another is the first full week in January. With the combination of those two parameters you should be able to do what you want.
thx for all the replies. I went to msdn too and found the specs on the datepart function: http://msdn.microsoft.com/library/de.../d6/s5b208.asp
However, when i specify the following: datepart("ww", 12/30/2004, 1,2), it would not display week 53!! However, to make it work for our situation here (we only work monday to saturday), this works for us: datepart("ww", 12/30/2004, 2,2) and returns the proper results (53) and thereafter as well. However, our calendars are numbered with the first day of the week being sunday...but oh well.
Hope that made sense.
Still kind of confused as to why i cannot specify datepart("ww", 12/30/2004, 1,2) and have it display week 53, but I got it working close enough now.