subtract weeks

ArielNF93 — Fri, 11 Feb 2022 00:15:01 GMT

Hi all,

I have the following problem:

I need to subtract weeks, and I would like to know if it is possible.

For example, I have loaded a qvd of transactions, where I do a max(date).
Then, with the peek function, obtain a variable with the maximum date.

Then I load another QVD, where I do a max(week) and I do a where date = variable created previously.

So I have a variable with the maximum week of the qvd loaded.

I do all this because I need to bring information from 12 weeks back from the maximum week.

So my idea is to subtract 12 weeks back. But I can't get to week 47 (currently the maximum week is 7).

I don't know if someone could help me with this problem or maybe you have another better idea to do this.

Re: subtract weeks

tresB — Fri, 11 Feb 2022 05:16:11 GMT

Week(WeekName(yourmaxdate,-12))