Forum Discussion
Solved
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...
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!
HotChilli
Community Champion
Community ChampionWhat 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.