Date conversion

[wikus]

I am trying to convert a general formatted field in power query to a date mm/dd/yyyy but are getting errors.
Any help will be appreciated.
31.12.2023
28.2.2020
16.3.2019

 

[LVExcel]

I am trying to convert a general formatted field in power query to a date mm/dd/yyyy but are getting errors.
Any help will be appreciated.
31.12.2023
28.2.2020
16.3.2019

Sorry, not too familiar with Power Query, I'm sure someone will reply, but in the meantime, what I do is select the entire column, then do a Find/Replace; Press Ctrl-F then find dot (.) and replace with slash (/).

 

[GraH]

I am trying to convert a general formatted field in power query to a date mm/dd/yyyy but are getting errors.
Any help will be appreciated.
31.12.2023
28.2.2020
16.3.2019

You define data types in Power Query, not a format.
So you need to set it as a date type. The formatting is done in Excel.

Look for an earlier step with #"Changed Type" as name. It might as well be this field was seen as a text field. If so this step should be changed or removed. In the previous step you can use the change type from locale. Here you need to define the source setting. It will show up as a data matching your locale setting.

With my local setting is works with simply defining the data type date, since the source setting matches my local setting.

9 out 10 you need to go via "Using Locale..."

Then use one of the many options that accept this source format.