3 Replies Latest reply: Jan 17, 2018 10:11 AM by Yeo Poh sai RSS

    My month_n script is not working ?

    Yeo Poh sai

      Hi All


      I have below script work fine :-


      SubField([Expected Close Date],'-' ,3) as Year,


      Now i need to create month_n field :-


      (year(today()) - year(@50:60T)) * 12 + month(today()) - month(@50:60T) + 1 as Month_n,


      But above script return no value.


      The purpose of month_n is allow me select


      month_n = 0 , that is current month.

      month_n = 1 , that is Next month

      etc

      .

      Can some one help me.


      Paul