9 Replies Latest reply on Apr 2, 2018 11:34 AM by faizan.jamil

    Tableau Misintrepreting Date Data

    faizan.jamil

      I am attempting to import a CSV containing data associated with different dates and times. The data in the CSV is being output chronologically, however for some reason Tableau is interpreting dates towards the end of data as occurring in the AM rather than PM, as the CSV file shows when viewed through Notepad++ and Excel. Why is Tableau doing this? How can it be fixed? Screenshots below:

       

      Time being converted from PM to AM in Tableau:

      tableau1.PNG

       

      CSV as seen in Excel:

      excel1.PNG

      CSV as seen in notepad++. Notepad++ has a format change from 24h time to AM/PM around this time, but it's switching from PM to AM format.

      np++.PNG