Forum Discussion
Format 31.01.2023 as text on Date format
Hello, I have a problem.
I have in my column such a value: 31.01.2023 (as text)
I want to receive datatype "31/01/2023". When I use locale (united kingdom) I always receive 01/31/2023 but it's not correct.
Do you have any ideas how to recieve "31/01/2023" datatype?
What is your location and regional settings?
It looks like you can just change the datatype to date or parse it as a date (from the ribbon on the Transform menu -> Date section) but I suspect it's a little more complicated than that otherwise you would have tried it.
I solved the issue. I set in my personal settings UK type. Thanks a lot!
3 Replies
- HotChilli
Community Champion
What is your location and regional settings?
It looks like you can just change the datatype to date or parse it as a date (from the ribbon on the Transform menu -> Date section) but I suspect it's a little more complicated than that otherwise you would have tried it.
I solved the issue. I set in my personal settings UK type. Thanks a lot!
Load your data into power query, after that select the column containing the date values you want to convert. Go to the transform tab and click on replace value and in the replace values dailbox in the value to find field, enter "." and in the replace with field, enter "/" and make sure to check the replace current selection only option and click ok button to replace all periods with slashes in the selected column. Now that you have the date values in dd/mm/yyyy format, and now you can change the data type to a date.
