Forum Discussion

abegum's avatar
abegum
Frequent Visitor
5 years ago
Solved

Change Format DATE

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

 

Date
Query Editor
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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

     

2 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    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