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
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