0 Replies Latest reply: Nov 3, 2017 1:41 AM by Divyanshi Bansal RSS

    using concat() function in an expression

    Divyanshi Bansal

      Hello,

       

      I have an expression :

      (text(Date(Date#((If(num(month(date#(GetFieldSelections(Mon),'MMM')))<4,num(month(date#(GetFieldSelections(Mon),'MMM')))+9,

      num(month(date#(GetFieldSelections(Mon),'MMM')))-3)),'MM'),'MMM')))

       

      This expression basically return the month name after all computation.

      I want to use the CONCAT() function in this expression in order to get  multiple months name at the same time i.e. Apr, June... and so on.

      The expression I m using is

      Concat(Distinct ((text(Date(Date#((If(num(month(date#(GetFieldSelections(Mon),'MMM')))<4,num(month(date#(GetFieldSelections(Mon),'MMM')))+9, num(month(date#(GetFieldSelections(Mon),'MMM')))-3)),'MM'),'MMM')))),',')

       

      But not getting the result.

       

      Kindly help.