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

    Clean up a complex date/time field

    james.carrington

      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!