3 Replies Latest reply: Nov 8, 2013 5:21 AM by Ida Berg RSS

    Extract a number from a cell and turn it in a date

      Hey everyone,

       

      I have some datas (from a particular colomn) that are showed like this in my source: 20131022 ****** Projects, Operations and maintenance quarterly review

       

      I would like to extract and transform the 8 first numbers in a date.

       

      In my example: 20131022 will be extracted and transformed in the date 22/10/2013.

       

      I dont know how to do this in the script for this particular colomn called "List Name".

       

      Thanks in advance,

       

      best regards,

       

      Arnaud