Working with calendar weeks

Thu, 13 Jun 2013 09:06:55 GMT

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

Re: Working with calendar weeks

alexandros17 — Thu, 13 Jun 2013 09:19:02 GMT

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