Date format “MMM-YY" in September shows Sept. instead of Sep.

Published: 22 Sep 2023
Last Modified Date: 02 Oct 2023


September is displayed as "Sept" (instead of "Sep") in Tableau Desktop 2022.2 or later when the workbook locale is set in Australian or British English.

User-added image
User-added image



  • Tableau Desktop 2023.2.1
  • Tableau Prep Builder 2022.1.1 and later
  • Windows 10
  • Australian and British English locale


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. 


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’.
Did this article resolve the issue?