2 Replies Latest reply on Jan 6, 2019 11:45 PM by mausami sharma

    How to show last 3 months data On Year Change

    mausami sharma

      Hi All,

       

      In my report i have to show only last 3 months data i.e Current Month -1 .

       

      I am using   MONTH([Month])=MONTH(TODAY())-1

                          MONTH([Month])=MONTH(TODAY())-2 ,

                          MONTH([Month])=MONTH(TODAY())-3 

       

      Here Month is a data field.

       

      But on year change it is not working.

       

      Could anyone please suggest any work around .

       

      Thanks

      Mausami