How to convert string to date format in Tableau

Question

I want to parse the following string

Wed Nov 18 20:22:45 +0000 2015

to date and time format in Tableau. Any idea how to use calculated fields? Tableau using the calculated field and DATEPARSE function? 

Thanks

Answer 1

• Use the following code:

Dateparse('EEE MMM dd hh:mm:ss Z yyyy', [YourString])

• Refer to http://userguide.icu-project.org/formatparse/datetime for a full list of parameters to specify your date.

Firstly register yourself in an industry-recognized Tableau Certification such as you can register for our Tableau Training Course.