12 Replies Latest reply on Sep 16, 2016 7:29 AM by Sathyan Kallamparambil

    How to convert text date to Calandar date?

    Sathyan Kallamparambil



      I was just wondering if we can convert the date, currently coming as text to date function.

      Below is an example


      Mo_ID                                           Month 

      (This is what I have as text)          (This is what I want)


      201601                                   01/01/2016

      201602                                   02/01/2016

      201603                                   03/01/2016

      201604                                   04/01/2016

      201605                                   05/01/2016


      Can this be doable using the calculated field?