4 Replies Latest reply on Jan 12, 2018 12:04 AM by Norbert Maijoor

    Previous 8 Weeks Time Period

    Anudeep Marupaka

      Requesting all great minds to help me out.

       

      I am trying to filter the Last 8 week time period by using this calculation:

       

      IF DATEPART('week', [Close Date]) < DATEPART('week', TODAY()) -8

      OR DATEPART('week', [Close Date]) > DATEPART('week', TODAY()) -1

      THEN "Exclude"

      ELSE "Include"

      END

       

      It worked fine until the start of new year and then it stopped working maybe because it couldn't recognize the week of previous year. So I found a workaround to get the last 8 weeks by using the following calculation but it is rolling data which causes the data to change daily.

       

      IF [Close Date] < TODAY() -56

      OR [Close Date] > TODAY() -7

      THEN "Exclude"

      ELSE "Include"

      END

       

      What I am looking for is the Last 8 week filter that doesn't change until next week. Any help would be appreciated.