5 Replies Latest reply on Jun 4, 2013 12:42 PM by esc esc

    Import Date Issue

    esc esc

      I am trying to import a pretty simple text file that has a date field as follows:  YYYY-MONTH (e.g.  2012-May).   When I import the file in Tableau the field is imported as a string.  When I try to change data  type to "date" I am not sure what it is doing but I get a numerical value like 4714 and I can no longer see the date  values or work with them as dates.  What is the best way to convert these values so they are recognized as YEAR-MONTH in Tableau?  Example table below.

       

      Thanks in advance!

       

      esc

       

       

       

       

       

       

      ##########Example

       

      YEAR-MONTHNAMECOLORTotal Count
      2012-MayICECREAMRoyal BLUE352
      2012-JuneSHERBERTRED14
      2012-MaySHERBERTORANGE1