Velg en organisasjon
Date format “MMM-YY" in September shows Sept. instead of Sep. in Tableau Desktop and Prep Builder
Publiseringsdato: 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.
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.
Flere ressurser
- 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-artikkelnummer
001497540
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
