3 Replies Latest reply on Sep 12, 2016 3:51 PM by Russel Quan

    Excel Date MMM-yy doesn't Pivot correctly

    Russel Quan

      I have an excel table with dates in the Mmm-yy format.


      When I pivot the values in Tableau and change the type from Abc to Date, it returns Nulls.


      If I change the format to mm/dd/yy, then the pivot and type change from Abc to Date works fine.



      I'd like to leave the excel table in its original format.

      Any suggestions?


      Thanks in advance.  Russel