Loading

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

Fecha de publicación: Feb 24, 2026
Descripción

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. 
 

Solución

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. 

Recursos adicionales
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’.
Número del artículo de conocimiento

001497540

 
Cargando
Salesforce Help | Article