Forum Discussion

Aamir_khan's avatar
Aamir_khan
Kudo Collector
6 years ago
Solved

Change Text date format to Date type

Hello All

 

I am facing some issue while Change Text date format to Date type 

 

I want Change Text date "2020-04-21" format  to Date type 2020/04/21 but how?

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Aamir_khan 
    right click Date colum ->Chage type ->Using locate

    For more details , please refer to this post.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Date = Date(left([column],4),mid([column],6,2),right([column],2)

     

    If it has already column detected as date try to change the format

     

    You can also create a formatting

    Formatted Date = format([New date],"YYYY/MM/DD")

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Aamir_khan 

     

    You can use the Power Query editor.

    Or change the Data Tape to Date in the model
     
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • Aamir_khan's avatar
      Aamir_khan
      Kudo Collector
      6 years ago

      I try this solution but in some of the date gets errors

      • Mariusz's avatar
        Mariusz
        Community Champion
        6 years ago

        Hi Aamir_khan 

         

        Can you paste a sample with some good and bad ( errors ) examples?

         

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        LinkedIn