6 Replies Latest reply: Jun 17, 2013 6:54 AM by Selvakumar S RSS

    String or Number to Date Format

      Hi All,

       

      I need to convert " 200011" to Year and Month Format like this " Nov  2000".

       

      I tried this

       

      =

      Date# (01012001, 'MMM YYYY')

       

      but it not working. Is there any way to do this.

       

       

      Thanks,

      Selva