Forum Discussion

Joycelu819's avatar
Joycelu819
Regular Visitor
4 years ago

Date format error

Hi guys,

 

I changed data type for a column of dates. Most are fine, but some with format of "DDMMYY" had errors. And, some others look correct to me, but Power BI was showing message "DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
Friday , 7 May 2019". How can I fixed all of these at the same time? Thanks.

 

Joyce 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Joycelu819 , If your source date has different format, then you can issue like that

     

    Can you share sample data and sample output in table format?

    • Joycelu819's avatar
      Joycelu819
      Regular Visitor
      4 years ago

      amitchandak Thanks for your reply.

       

      Tuesday, 30 June 2020

      Friday, 26 June 2020

      Tuesday, 7 Jul 20

      Sunday,  5 Jul 2020

      Wednesday, 12 Aug 2020



      Joyce

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, Joycelu819 

        I cannot reproduce the problem. The data can be successfully converted into date type on my side.

        Are there other errors in the advanced editor?

        You can try to change the data type and select the region locale in advanced editor.

        Best Regards,
        Community Support Team _ Eason