Loading

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

Julkaisupäivä: Feb 24, 2026
Kuvaus

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. 
 

Ratkaisu

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. 

Lisäresurssit
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’.
Knowledge-artikkelin numero

001497540

 
Ladataan
Salesforce Help | Article