Viewing post 1 (of 1 total)
I just came across this and created a case statement to get around this.
CASE WHEN DATEPART(ww,Driver_summary.Dor_date)=53 THEN 1 ELSE DATEPART(ww,Driver_summary.Dor_date) END AS WeekNum
January 11, 2013 at 2:00 pm
#1576499