Change Format DATE

[abegum]

I WANT TO CHANGE THE FORMAT FROM THE LEFT TO THE RIGHT ON QUERY. IS IT POSIBLE?

[v-deddai1-msft · Accepted solution]

Hi @abegum ,

You can do it in power query. Just create a new custom like below:

{Number.From([DEL])..Number.From([AL])}

Then expand the list to rows and change it to date type:

For more details, please refer to https://www.youtube.com/watch?v=u3HLseZxSj4

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[lbendlin]

Power query allows you to specify the source culture of your date information

Date.FromText - PowerQuery M | Microsoft Docs

You get an ISO-8601 date which you can then transform again into the target culture.