Forum Discussion
Dates in PowerQuery
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?
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
4 Replies
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.
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).
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
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!
