Hi I am posting this after spending a while banging my head against an issue with dynamic dates.

I am trying to define some criteria to show aggregations for a number of previous fiscal weeks. I am using the offsets to specify year and week times but there comes a point where the offset doesn't make a difference. e.g.

Week - 1 resolves to (Week 2 2018 (WE 11/11/2017)) - which is correct for our fiscal periods
Week - 2 resolves to (Week 1 2018 (WE 04/11/2017)) - correct again
Week - 3 resolves to (Week 52 2017 (WE 28/10/2017)) - correct
Week - 4 resolves to (Week 52 2017 (WE 28/10/2017)) - shouldn't it be week 51?
Week - 5 resolves to (Week 52 2017 (WE 28/10/2017)) - still week 52

(Images attached)





It follows this pattern for every offset beyond what resolves to week 52.

Does anyone know what I've got wrong here?

Any help would be greatly appreciated.

Thanks, Jon.