From the course: Tableau 10 for Data Scientists

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Convert string to dates with automatic dateparse

Convert string to dates with automatic dateparse - Tableau Tutorial

From the course: Tableau 10 for Data Scientists

Start my 1-month free trial

Convert string to dates with automatic dateparse

“

- [Instructor] Probably the hardest data type you'll have to typically deal with are dates. The reason for this is that there are so many different date formats are in use. Different databases have different formats. If you're using external data, sometimes there can be really complicated formats that are easy to read to a human, but to Tableau or to a database, they're almost incomprehensible. Now for a while now, Tableau has had the DATEPARSE function which allows you to write some code to convert a string into a date. Now depending on how complicated the date could be, that requires some complicated code and knowing how to convert one to the other. In 10.2, Tableau has improved the automatic DATEPARSE function. Let's take a look at this and compare the previous method of doing the date parse calculation and the automatic method. So for this, we're going to use the Date Example file in the Exercise Folder. If you open this up, we see it's just simple file with two columns of data…

Contents