3 Replies Latest reply on Nov 4, 2016 8:12 AM by Norbert Maijoor

    Clean up a complex date/time field


      I need to clean up a date/time field so that Tableau can read it as a date field type.


      Source fieldDesired format for calculated field
      Thu Jun 12 15:19:51 GMT+0100 201412 Jun 2014



      In Excel I can use the following formula to clean up the formatting of the source date field:


      =TRIM(CONCATENATE(MID(A7,9,2)," ",MID(A7,5,3)," ", RIGHT(A7, 4)))



      Is it possible to do the same with a calculated field in Tableau?



      Thank you!