• Since you're wanting to compare 2 period across years; why not use the week of the year [datepart(wk,somedate)] to create begin and end ranges for each year. You'd compare the 1st week of September 2015 [which starts Aug 30] against 2016 [which starts Aug 28th]. Comparisons should be a little closer to reality that way.

    RMc