Forum Discussion
How to change ordinal data to normal data in Power Query?
Good morning, Please does anyone know how I can change a date column written like this May 13th, 2007, to a normal date like 13/05/2007 and July 2nd, 2019 to 02/07/2019? I've already tried using...
Hi mathetes, thanks for answering me. The problem is, I need to do this in Power Query as I'm trying to automate the process for a client. I can do this with a lot of substitutions on some columns that will generate a lot of steps in power query. What I'm looking for is a shorter way to replace all these ordinary dates (from text) to date.
The problem is, I need to do this in Power Query as I'm trying to automate the process for a client.
Ahh, well, I'm sorry but although I know of Power Query, it's only recently been available in the Mac ecosystem, and I've not yet had occasion to learn to use it.