Latest 5 weeks selection

[raju_salmon]

Hi,

I am using Calendar from my DB, not generating from QV.

Please find the attached sample QVW, here i have created a button to select latest 5 week selection. However i cannot able to write current string. Which field i need to use for this?

Can anyone help me on this?

[raju_salmon]

Sorry for the confusion.

Please find the attached QVW and my string to select last 13 weeks based on MAX(DATE).

It is working, however i have question if MAX(DATE) changes, will it work if i use (no.of days if i deduct? -78 days?

Because i need to calculate for last 13months as well.

[tresB · Accepted solution]

You could rather use Week Shift paramter like:

='<=' & Date(WeekEnd(MAX(DATE))-1) & '>=' & WeekEnd(MAX(DATE),-13)

[tamilarasu]

Hi Raju Salmon,

I guess the above expression works. You can check by modifying date in your initial load.

Weekend will return the last Sunday date. So I just use -1 as week offset to find the last Saturday.