Rolling Weeks over 2 different years

maudifer — Sat, 16 Nov 2024 21:35:08 GMT

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 ?

topic Rolling Weeks over 2 different years in App Development