I was writing an SSRS report, or rather modifying one of the existing SSRS reports that come packaged with Assistance Software’s PSA for Microsoft Dynamics CRM 2011, and when trying to group entries by week number (working on a billable hours report), I noticed that the function was returning the week number based on the DAY of the month value, instead of the actual MONTH value.