1 Reply Latest reply on Aug 17, 2018 8:02 AM by Jon Grote

    Date Time Field Importing Incorrectly

    Jon Grote

      Good Morning Everyone,

       

       

      I'm encountering an issue when connecting to an Excel workbook. I have several date time fields in mm/dd/yyyy hh:mm:ss AM/PM format. In the data preview screen within Tableau, I see the values as represented in Excel. However, when I add the field to a visualization in the workbook, Tableau has changed all of the time stamps to 12:00:00 AM.

      Closed Date - Data Preview.png Visualization View.png

       

      Ideally I'd like to build a heat map showing activity by hours, but without the correct time stamps, my data points are useless for that purpose.

       

      Any ideas would be most appreciated!

       

       

      Thanks,

       

      Jon