4 Replies Latest reply on May 30, 2017 12:55 PM by Teresa Wright

    Tableau converting date field from hh:mm ampm to date/time

    Teresa Wright

      I need to find out how to correct date fields on the data source tab.  My source file is in Excel, and the date field is formatted as Time.

       

      Screen shot Excel source file

       

      time.jpg

       

      Data is imported to Access where date field is in hh:mm format.

       

      time.jpg

       

      But when I connect to the data in Tableau, the field gets converted.  Is there a way to correct this?

       

      time.jpg

       

      Thanks!