While convert String to datetime

Help Studio
, ,
1

while converting into date time I am getting this error

image
image1674×412 114 KB

2

Hi,

It seems your input string is empty. Can you check your input?

Regards,

3

HI @Parul_Yadav

The 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?

DateTime.ParseExact(CurrentDate.Trim,"dd-MMM-yyyy",System.Globalization.CultureInfo.InvariantCulture)

Regards
Gokul

4

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.

5

Hi,

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?

Regards,

6

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

image
image695×504 15.1 KB

Regards
Gokul

7

No with expression I am getting same error

8

Can you share this detail? @Parul_Yadav

have you tried like this?

9

value of data table getting from data scrapping

image
image1544×50 4.03 KB

10

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

Regards
Gokul

11

Yes,

image
image1485×703 46.7 KB

12

Sorry @Parul_Yadav Can you try with If activity

Not String.IsNullOrEmpty(CurrentDate.tostring)

image

Regards
Fokul