6 Replies Latest reply: Nov 28, 2017 7:04 AM by Pooja Goswami RSS

    Month name to Date format

    Pooja Goswami

      Hello,

       

      I have a expression which is giving me the Quarter End in form of month i.e. if I select Quarter 1 then I get June as Quarter end.

      The Expression is:

      concat(distinct month(QuarterEnd(Date(Date#((If(num(month(date#(Mon,'MMM')))=1,num(month(date#(Mon,'MMM')))+11,

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

       

      Now I want to convert this month name into the date format of the same year.

       

      Kindly help.