Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to show the last 6 rolling week, but they are over 2 different year:
2018:49,50,51,52
2019: 1,2
For my rolling 12 months overlapping 2 years, iIuse this variable:
vCurrMonthID
=(($(vCurrYear)-1)*12)+$(vCurrMonth)
$vCurrYear=2019 vCurrMonth=1
And it works. But I can't seem to figure out how to make it work for weeks
For weeks, i would like to where vCurrWeekID would work like the month variable, but i don't how to write it.
I tried:
vCurrWeekID
=(($(vCurrYear)-1)*52)+$(vCurrWeek)
But it does not work.
Please, can you help me figure this out ?