Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can you please help me to fix this issue :
I have a list of calendar weeks in this format YYYYWW stored in a calendar table :
201301, 201302 , ...., 201324
And i want to get in the same format the last n weeks.
For example:
If i choose the 201304 and n= 6 weeks
I have to get this :
201303 201302 201301 201252 201251 201250
Thanks in advance
You need 6 (n) variables,
the first one is
=if(right(GetFieldSelections(week)-1,2)='00',
(left(GetFieldSelections(week),4)-1)*100+52,
GetFieldSelections(week)-1
)
other 5 are the same