Custom Weekly Demand Not working due to YEAR

[ckrusen (Calvin Krusen)]

First off, please use the code formatting as described in:

Code Syntax Highlighting in Posts

The test below ```cs public void test() { MessageBox.Show("testing"); } ``` will produce public void test() { MessageBox.Show("testing"); } The 3 back tics ``` signify the start and end of a code block. The first set of 3 back tics are followed by the language type you have posted for be it C#, VB, or SQL. The languages available to use are cs, xml, ini, objectivec, sql, vbscript, vbnet, sql, txt. All the languages that could be included in the above list can be found here. highlight.j…

The DATEPART() function can actually return week numbers as high as 53.
DATEPART(ww, '2020/01/01') = 1 (Wed of the 1st week)
DATEPART(ww, '2020/01/05') returns 2 (Sun of the 1st week)
DATEPART(ww, '2020/12/26') returns 52 (Saturday of the 52 week)
DATEPART(ww, '2020/12/27') returns 53 (Sunday of the 53 week)

you need to account for week #53. In your buckets (that use number of weeks relative to current date) Week 53 is the same as week 1 of the following year.