6 Replies Latest reply: Jul 27, 2016 8:19 AM by Sunny Talwar RSS

    Selecting the last 6 weeks

    Guillermo Lo-Kioeng-Shioe

      Hi,

       

      So I have been trying to setup a report where i select the last 6 weeks. So far i have been able to get the last week with the formula:

      =week(now()-7) as a filter.

       

      How can i transform this filter into it selecting the last 6 weeks instead of just the last week?

       

      Thanks in advance.