topic Re: Change Format DATE in Report Server

Change Format DATE

abegum — Mon, 04 Jan 2021 16:40:45 GMT

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

lbendlin — Mon, 04 Jan 2021 21:27:32 GMT

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

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

v-deddai1-msft — Tue, 05 Jan 2021 08:18:22 GMT

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:

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