Button to Select Last 4 weeks of Sales

[NickBentley82]

I am trying to create a button to select the last four weeks of sales, rather than selecting each week individually from the list box. 

I am currently using the variable dMaxFYWeek to get my current financial week, but I am having trouble getting this week plus the previous 3 selected in the list box with the button. 

Thanks in advance!

Cheers, 

Nick 

[MayilVahanan · Accepted solution]

Hi @NickBentley82 

Try like below

='>='&WeekStart(Max(Date),-3)&'<='&WeekEnd(Max(Date),0)

[NickBentley82]

Thank you

Mayil Vahanan R.

Works Well!