1 Reply Latest reply on Apr 29, 2013 6:18 AM by Alex Kerin

    Date and Time not recognized

    Jake Hann

      I'm running a MySQL server and trying to convert my date column into Tableau but it does not recognize the format.  Do I need to create a calculated field?

       

      Here is the format:
      Fri Feb 15 16:00:46 +0000 2013

        • 1. Re: Date and Time not recognized
          Alex Kerin

          If that isn't a real date in SQL, but rather a string, then yes. You could try datetime(), but I suspect that won't work. You will probably have to use a datetime with a bunch of mid(), left(), and right(). There have been several examples of this on the forum in the last week.