1 Reply Latest reply: Apr 5, 2017 9:25 AM by Aar Kay RSS

    Months Comparison in if condition

    Supriya R

      Hi,

       

      i have below formula

       

      if(match(Date(MonthStart(today())-1,'MMM')='mar','apr')>0,1,2)

       

      If previous month is mar or apr, i need to display as 1.  But it always displays else part. ie 2.

       

      Whats wromg in my code?