Forum Discussion

Arul's avatar
Arul
Super User
7 years ago
Solved

Error in date column

Hi, I got the below error in my date column of my dataset. Any help would be aprreciated. DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 13/04/18 Thanks, -Arul...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Arul ,

     

    Remove the last "Changed type" step under "Applied steps" list. Right click the date column, choose "Change Type"->"Using locale", then, select the right locale which displays the matched date format.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Arul ,

 

Remove the last "Changed type" step under "Applied steps" list. Right click the date column, choose "Change Type"->"Using locale", then, select the right locale which displays the matched date format.

 

Best regards,

Yuliana Gu