Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to parse the date

Hi

 

I have a dataset which has 15000 records. I have a order date and time which has 01/22/19 21:25. I split the column and seperated the time. Now I have a date column which is in text.

 

I am getting below error when I tried to convert data type into a date

 

 

 

Please advise. I have filtered out the null values. 

 

 

 

Need Help
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    I am glad that you could get the solution. You can accept your own reply to close this topic.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Thanks, I solved this issue with Locale by converting the date into English(US). Just saw the other posts and solved. Sorry, I am a newbie to the community. Didn't see the post properly.

     

     

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    I am glad that you could get the solution. You can accept your own reply to close this topic.