This content has been marked as final. Show 3 replies
I need to clean up a date/time field so that Tableau can read it as a date field type.
|Source field||Desired format for calculated field|
|Thu Jun 12 15:19:51 GMT+0100 2014||12 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?