Skip to main content

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Ⓜs a , It will give you the datetime D1 in correct format. 


Then you can use DateTime: To String 


@Prade1645, has the issue been resolved? If not, please let us know, and I will try to help you.


Reply