1 Reply Latest reply on Jan 30, 2017 6:04 PM by Shinichiro Murakami

    Failure to recognize yyyymmdd as date from excel (but not csv)

    Christopher Mederos

      Running into an annoying issue with date recognition -

      • When connecting to a csv Tableau is able to identify data formatted as 'yyyymmdd' as date.
      • When connecting to an excel file with 'yyymmdd' stored as a 'general' column, Tableau is not able to recognize the data as date. Even if you force the measure type to date the records all read null.

       

      Does anyone know why this is an issue? I realize you can work around using calculated columns and date parse.  However, I don't want to add unnecessary calculations if there is a way to correctly load the data.

       

      Thanks,

      Chris