13 Replies Latest reply: Feb 17, 2016 2:20 AM by Rajesh Kumar RSS

    Convert YYYYMMDD into Monthname

    Hasvine Dhurmea

      Hello All,

       

      I need to convert 'YYYYMMDD' into monthname like 'Jan. , Feb. , etc....'

       

      I manage to convert it into date using the below:

       

      Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY') as Date_Interview,

       

      Any idea?

       

      KR,

       

      Hasvine