String was not recognized as a valid DateTime when trying to pull working dates of the week

Help Activities
, ,
1

I am running into the following error message:

String was not recognized as a valid DateTime.

2022-10-07 15_14_01-TimeEntryReminders-HoursLogic - UiPath Studio
2022-10-07 15_14_01-TimeEntryReminders-HoursLogic - UiPath Studio824×480 19.8 KB

Here is the full code below:

DateTime.ParseExact(startDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)

Any thoughts on what the issue might be?

Thanks!

3

@I_Am_A_RPA_Noob
Its happening due to possible case.
DateTime.ParseExact(startDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)
This expression returns datetime variable and you need a string.

So please try this one.

DateTime.ParseExact(startDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat).ToString

4

Thanks for your input. I tried out your suggestion but I ended up getting the following error message.
2022-10-10 10_20_48-TimeEntryReminders-HoursLogic - UiPath Studio

5

Hi @I_Am_A_RPA_Noob

Check out this expression

DateTime.ParseExact("startDate",{"MMM dd, yyyy","MMM d, yyyy","MMM d, yyyy hh:mm tt","MMM dd, yyyy hh:mmtt"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MMM dd, yyyy")

Regards
Gokul

6

@I_Am_A_RPA_Noob
DateTime.ParseExact(startDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)

7

Please check your input variable. There will be some issues with it.

Regards

Sreejith S S