KNOWLEDGE BASE

Date Format Could Not Be Recognized Correctly in Tableau Prep


Published: 16 Nov 2021
Last Modified Date: 16 Nov 2021

Issue

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

Environment

Tableau Prep Builder

Resolution

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

Cause

The Date Format does not match the default Locale.
Did this article resolve the issue?