KNOWLEDGE BASE

Calculated Field Returns Incorrect Results After Changing Locale


Published: 04 Oct 2016
Last Modified Date: 04 Oct 2016

Issue

After changing the workbook locale, a calculated field containing date literals returns incorrect results.


 

Environment

  • Tableau Desktop
  • Extract

Resolution

Ensure that the date literals are formatted according to the locale setting originally used in the workbook, rather than the new locale setting. 





 

Cause

Recognized formats for date literals vary depending on workbook locale. For example, when set to "English (United States)", we recognize dates in the form #MM/DD/YYYY#, and when set to "English (Ireland)", we recognize #DD/MM/YYYY#. An extract only recognizes the acceptable formats from its original locale.


 
Did this article resolve the issue?