Forum Discussion
Convert a date in the right format
Instead of changing the default behavior or your query editor, you can also set the culture manually in the step where you transform column types.
Set the optional culture parameter to "en-US" to interpret dates as "mm/dd/yyyy" instead of "dd/mm/yyyy".
https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes
Hi maxduff59 ,
In Power Query, go to File > Options & Settings, then navigate here to adjust how PQ deals with regional settings globally:
And here for the specific file:
Pete
Instead of changing the default behavior or your query editor, you can also set the culture manually in the step where you transform column types.
Set the optional culture parameter to "en-US" to interpret dates as "mm/dd/yyyy" instead of "dd/mm/yyyy".
https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes