String was not recognised as a valid time error in Build Data table

Hi @Sneha2369

So if you are getting the final output correctly as shown above then just for formatting you can use Change Cell Type Activities by @balupad14

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

I’m Unable to download this package for licensed version.

One simple way to do it is to keep 2 datetime variables, one called OldDate and one called NewDate.

In a try-catch, try assign NewDate = (fill in with existing code, either parseexact(), or cdate()
catch system.exception assign NewDate = OldDate

then at the end of the loop, assign OldDate = NewDate.

This way the new date will be found by converting the string. If there is an error converting the string (generally because it’s empty) then it will use the previously used date. At the end of the loop, it will change the OldDate variable to the newest date you’ve used.

A better way to do this would be using the DateTime.TryParseExact method, but the various .TryParseExact methods are kind of hard to work with in UiPath in my opinion, and my solution above accomplishes the same thing.

Could you please give a sample workflow for it

See attached: delete2.xaml (10.8 KB)

@Sneha2369

Check as below

Hope this helps

Thanks

Here is the package.

Here is the video explanation

Regards
Balamurugan.S

Hi, Balareva…there is no connect in the version I’m using I have settings, Project Dependencies, All Packages, Local and nuget.org.

1 Like

Hi @Sneha2369,

Check it in the nuget.org.

Thank you
Balamurugan.s

It helped me to some extent Thank you @Srini84

1 Like