Loading

Date Format Could Not Be Recognized Correctly in Tableau Prep

Udgivelsesdato: Apr 13, 2024
Beskrivelse
Sometimes the Date field cannot recognize the date correctly in Tableau Prep.
For example, the below data are showing the dates in August as [dd-mm-yyyy], but Tableau Prep will recognize the data as [mm-dd-yyyy]. 
DateValue
04-08-2021 00:00:0044
05-08-2021 00:05:0055
06-08-2021 00:10:0066
07-08-2021 00:15:0077
08-08-2021 00:20:0088
09-08-2021 00:25:0099

User-added image

Cause

The Date Format does not match the default Locale.
Løsning
Please select another [Local] whose data format is [dd-mm-yyyy], such as Canada or Singapore. 
The default Locale is [English(United States)], and the default date format is [mm-dd-yyyy].
Locale.tflxPlease review the attached Flow, Locale.tflx, for details.
User-added image
User-added image
Vidensartikelnummer

001474575

Vedhæftede filer

Locale.tflx

3 KB

 
Indlæser
Salesforce Help | Article