This content has been marked as final. Show 2 replies
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).