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

    How to convert text date to Calandar date?

    Sathyan Kallamparambil

      Hello,

       

      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?

       

      Thanks,

      +Sathyan