Last Modified Date: 03 Jul 2017
Option 1:Convert the string field to a date or datetime type in the underlying database.
Option 2:Use an extract. For more information, see Extracting Data in Tableau Help.
Option 3:Use custom SQL to wrap the date dimension interpreted as a string with the date() function. For more information, see Connecting to a Custom SQL Query in Tableau Help.
CauseThe date/time field from the live data source is of type string. When using a live connection, Tableau Desktop relies on the remote database to perform the conversion from string to date or datetime. Because most databases do not handle these conversions uniformly, Tableau Desktop is unable to enforce a standard behavior.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials