Dates in PowerQuery

[Ed1100]

Good day,

I am having an issue where the dates from a raw data file are showing correctly as MM/DD/YYYY HH:MM (military time). When I add the data file into PowerQuery, it changes it automatically to DD/MM/YYYY HH:MM. Is there a way to default the data input to a specific format?

[Ed1100]

When I bring the data in, it comes in as a Text.

After I Promoted Headers, I try to Changed Type to Date/Time, it errors out and I cannot figure out why (see error on bottom).

[v-xinruzhu-msft · Accepted solution]

Hi @Ed1100 

Did you set it as the steps i followed before, the locale shoud be set as US. Can you provide the steps you operated?

Best Regards!

Yolo Zhu

[Ed1100]

Hi Yolo Zhu, I was able to correct it by completed the steps with the Change Type with Locale. Not sure why it defaulted back. Thanks for your support!

[v-xinruzhu-msft]

Hi @Ed1100 

If your data format is "MM/DD/YYYY HH:MM", You can select the date column, then select change type->use locale.

Then select the data type to 'Date/Time', and select the locale to "US".

Output

And you can refer to the following link.

Change Type Using Locale with Power Query • My Online Training Hub

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.