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

    Month name to Date format

    Pooja Goswami



      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,



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


      Kindly help.