KNOWLEDGE BASE

Text Field Does Not Convert to Date on Mac


Published: 19 Nov 2014
Last Modified Date: 30 Aug 2016

Issue

When converting a text field with values similar to YYYY/MM or YYYY-DD-MM to a date field, the values are NULL in Tableau Desktop or Tableau Reader on the Mac.

Environment

  • Tableau Desktop 
  • Tableau Reader 
  • OS X
  • Excel

Resolution

As a workaround, use the DATEPARSE function to convert the text field into a calculated date field.
Did this article resolve the issue?