Last Modified Date: 02 Oct 2023
Environment
- Tableau Desktop 2023.2.1
- Tableau Prep Builder 2022.1.1 and later
- Windows 10
- Australian and British English locale
Resolution
This is due to the change in Unicode CLDR.Workaround 1
A potential workaround it to use the calculation "LEFT(string, number)" to convert "Sept" to "Sep".Workaround 2
Change the workbook locale to US English.Cause
This is due to the design change. Tableau Desktop uses Unicode CLDR to generate the date format. "Sep" was changed to "Sept" in Australian and British English locale in CLDR.Additional Information
According to Australia government website, the standard abbreviations for the months are:- January – ‘Jan’
- February – ‘Feb’
- March – ‘Mar’
- April – ‘Apr’
- May – retain as ‘May’
- June – retain as ‘June’ or shorten to ‘Jun’
- July – retain as ‘July’ or shorten to ‘Jul’
- August – ‘Aug’
- September – ‘Sept’
- October – ‘Oct’
- November – ‘Nov’
- December – ‘Dec’.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials