Loading

Date format “MMM-YY" in September shows Sept. instead of Sep. in Tableau Desktop and Prep Builder

Udgivelsesdato: Feb 24, 2026
Beskrivelse

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

User-added image
User-added image

 

Cause

This is due to the design change. Tableau Desktop (and Tableau Prep Builder) uses Unicode CLDR to generate the date format. "Sep" was changed to "Sept" in Australian and British English locale in CLDR. 
 

Løsning

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. 

Yderligere ressourcer
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’.
Vidensartikelnummer

001497540

 
Indlæser
Salesforce Help | Article