5 Replies Latest reply on Feb 12, 2019 9:29 AM by Nitya Goriparthi

    N Weeks data

    Nitya Goriparthi

      Hello,

       

      I'm using this formula to get N weeks data. But Our fiscal year stars on October 1 st, and as we changed to new year I could only go back to last 4 weeks since this Year (i.e. Year(TODAY()) has only 4 weeks but I need all weeks from start of my fiscal year.

       

      Note: [Weeks Back] is a parameter

       

      IF DATEPART('week',[Order Date])<    DATEPART('week', TODAY())

      AND DATEPART('week',[Order Date])>= (datepart('week',today()) -([Weeks Back]))

      AND YEAR([Order Date]) = YEAR(TODAY())

      THEN [Order Date]

      END

       

      Thank you!

      Nitya