AnsweredAssumed Answered

Extracting date from text

Question asked by tomo17 on Dec 17, 2013
Latest reply on Jan 19, 2014 by tomo17

Title

Extracting date from text

Post

     I have a field that has imported the date as a text e.g. Monday, January 25, 2013

     I have tried the calculation

Let ( Month = Ceiling ( Position ( "JanFebMarAprMayJunJulAugSepOctNovDec" ; Left ( DateText ; 3 ) ; 1 ; 1 ) / 3 ) ;
        Date ( Month ; MiddleWords ( DateText ; 2 ; 1 ) ; Rightwords ( DateText ; 1 ) )
      )

But this is not working.  I get how it works but am not sure how I can change it to work.  I would like to get an answer such as 25/1/2013

      

Thanks in advance

Outcomes