Multiple Date Format in Same Column

[croufspesi]

When I import sales data from 3 different companies, the dates are displayed in different formats within the same column

ImportedDate	CompanyName	ActualDate
1/3/2019	US Company	Januar 3, 2019
1/3/2019	Oz Company	March 1, 2019
1/3/2019	EU Company	March 1, 2019

I can identify MMDD vs DDMM because of the CompanyName Field.  I do also have a DateDIM, but couldn't quite figure out how to get one field for date that is standardized.  I'd like to be able to use a slicer for date to compare product sales between all 3 companies.  Any help is appreciated, thanks!

[harshnathani]

Hi @croufspesi ,

Please see the video from 17:36 to 21:00 to understand issues with dates.

You need to adjust your Locale settings.

https://www.youtube.com/watch?v=jN87y6TbWXI

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[croufspesi]

@harshnathani 

Think there must be something I"m still missing/not understanding.  I did watch the video and completed those steps using the locale settings, but it just caused errors within the date column