4 Replies Latest reply on Sep 11, 2013 12:02 PM by Thai Huynh

    Why Tableau recognizes Date table column as string?

    Thai Huynh

      I have a MS SQL table with a date/time data-type column and another column of date data-type.

       

      The date/time data looks something like this: 2013-09-11 10:46:05.040

      The date data looks something like this: 2012-01-02

       

      The problem we have is that for some of the users, Tableau interprets the date/time correctly and shows the calendar/clock next to the dimension. But it recognizes the date column as string and not date. Users have to manually "Change Data Type".

       

      Few other users connecting to the same database/table, all work just fine.

       

      I suppose I can change that date column to date/time and it will looks something like this: 2012-01-02 00:00:00.000

       

      But why Tableau does not recognize as date for some of these users?

       

      Thank you!