2 Replies Latest reply on Oct 17, 2013 9:37 AM by Matt Lutton

    Date string turns to NULL when I specify that it is a date

    Chris Fountain

      Data comes from an analysis server into an EXCEL Pivot table (I am not currently using  professional version so need to pull it in that way)

       

      The data comes in clean ready for tableau formatting wise, and the date comes in (exactly) as:

       

      Monday, January 02 2012

       

      Tableau recognizes it as a string. When I change it to a DATE (and view data) it reports it as NULL. When I change the date format in tableau to reflect the exact above (dddd, mmmm, d, yyyy) it still doesn't recognize it.

       

      How do I convince tableau to recognize it as a date (I cannot change the input format).

       

      Thanks!

       

      C