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 ,



      Here Month is a data field.


      But on year change it is not working.


      Could anyone please suggest any work around .