1 2 Previous Next 21 Replies Latest reply on Feb 11, 2019 5:13 PM by Dan Cory

    Date is randomly changing format form DD/MM/YY to MM/DD/YY

    Rogier Koning

      I have an Excel sheet as data source. One column is a date in dd/mm/yyyy format. If I read the data into Tableau it changes the dates. Days with lower numbers get switched with the month while those with higher day-number (more than 12) day in the correct order.

       

      Screen of the excel data:

       

      Excel-data-fo- import.jpg

       

      Screen of data after connecting with tableau:

       

      Import-Tableau-Date-wrong.jpg

       

      The 12/10/2018 gets changed in 10/12/2018 but the 13/10/2018 stays the same?

        1 2 Previous Next