Forum Discussion
Solved
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 automaticall...
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 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.