An exception occurred while parsing the date time.
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/45704c53-c03a-47ac-b81b-f6e60234874b.png)
I have a excel column invoice date looping as for each row when trying to convert date as dd-MM-yyyy in loop...getting the above error..”An exception occurred while parsing the date time.”
An exception occurred while parsing the date time.
I have a excel column invoice date looping as for each row when trying to convert date as dd-MM-yyyy in loop...getting the above error..”An exception occurred while parsing the date time.”
Hi ,
If you have the Date Time value in string format and while using DateTime: Assign to convert the string into a datetime value, Use the Custom Formats as M/d/y h:m:s a , It will give you the datetime D1 in correct format.
Then you can use DateTime: To String
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.