3 Replies Latest reply: Aug 2, 2018 5:12 AM by Chennaiah Nallani RSS

    =Month(Max(Date))-1  not working

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

      I have taken

      =Month(Max(Date)) then getting Jun as Max Month

      but when I have taken

      =Month(Max(Date))-1 then getting 5 instead of May.


      Please help me how to get May for =Month(Max(Date))-1 instead of number 5


      Thanks in advance.