3 Replies Latest reply on Aug 28, 2018 4:18 AM by Tim Dines

    Imported dates in non-US format showing as null

    RangaWal

      When importing Excel data, it appears some date columns in Australian format (dd/mm/yyyy) that don't conform to US standard are appearing as null.  eg 1/2/18 (which is 1st of February 2018 for me) import as 2nd January 2018.  Therefore, dates like 25/01/2018 (January 25 2018) are importing as null, as I presume Tableau sees it as an incorrect US date.  Weirdly, other columns in the same file, in the same format, are working fine.

       

      Any ideas how to fix it?