4 Replies Latest reply on Dec 6, 2018 4:24 AM by Zhouyi Zhang

    finding last 30 days ,quarter using parameter

    sunil sudendran



      is it possible to find the values of sales for last 30 using parameters from the given date.


      say today -last 30 days.

      all the values from 6th november till today


      [Parameter 3]=DATEADD('month',-1,DATETIME(TODAY()))

      AND [Parameter 4]<=DATE(TODAY())


      didnt wont work .


      please help if there is any other way to get the solution