while converting into date time I am getting this error
It seems your input string is empty. Can you check your input?
CurrentDate is returning the empty value can you check it out.
You can use Try catch activity to avoid this error.
Can you try with this expression?
Actually In Debug mode no error is occurred but while in Run mode I am getting this error , Don’t know how input string got empty just sudden, not this error all the time if I am runny 10 times getting this error 3-4 rest time it is running smooth.
How did you get the datatable? By DataScraping? If so, it might be timing matter.
To isolate cause, can you put 2 or 3 sec delay activity just before it?
Can you show us the Date column in the excel file with Screenshot?
Use Log message activity and Print the Date before the Assign activity
You can try to avoid this error by using Try catch activity like in the below image
No with expression I am getting same error
Can you share this detail? @Parul_Yadav
have you tried like this?
Every time you will get the Date value in the 12 column or the column will differ?
Every time when you run the bot the Date will get extracted?
You can try with Try catch approach
Sorry @Parul_Yadav Can you try with If activity