7 Replies Latest reply on Sep 19, 2013 12:03 AM by Dimitri.B

    Last Month , Last Quarter, Last year calculation based on parameter value

    pradeepbangarusamy

      I have a below report. The requirement is

       

      user to select the parameter like below

      "Last Month"

      "Last Quarter"

      "Last Year"

      "Current Year"

       

      In the report top, we are showing report Start Date & End Date to the user.

       

      For example if the user select "Last Month" Then the report filter startdate is  08/04/2013 and Enddate is 08/31/2013

      if the user select "Last Quarter" then the report StartDate is 04/07/2013 and End Date is 06/29/2013

      We should always Start With Sunday and End With Saturday.

       

      Report.JPG.jpg