Getting error message ,The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar

[Dimple_Mandal (UIPath Explorer)]

Sequence3.xaml (31.1 KB)

While entering the date (34/34/2021) that does not exist getting an error message instead of going in else loop.
Took input from user in “dd/MM/yyyy” format and Converting it into “MM/dd/yyyy” format…

[Yoichi]

Hi,

Can you try to use the following condition in IF activity whether input string is valid datetime string, in advance?

DateTime.TryParseExact(journeyDate,"dd/MM/yyyy",Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None,New DateTime)

or If use InvokeMethod activity, we can also get validation result as boolean and parsed result as datetime using following expression.

ret = DateTime.TryParseExact(journeyDate,"dd/MM/yyyy",Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None,resultDateTime)

DateTime.TryParseExact Method (System)

Regards,

[ppr (Peter | MVP)]

34/34/2021 is not a valid date
last month in year is 12
latest day in a month is 31

so it is reasonable that the exception states that this date is not conatined in a calendar

we can handle this with tryParseExact as mentioned by Yoichi

Also have a look here on how to handle multiple dateformats (TryParseExact, ParseExcact)

How do I parse in multiple datetime format strings into DateTime?

@gerlynn_lxy have a look here: Parsing_MultipleFormats_DTConfig.xaml (13.0 KB) the fourth argument within the ParseExact working with date formats is missing go eg for a DateTime.ParseExact(row(0).ToString.trim, arrFormats, cultureinfo, DateTimeStyles.None) where arrFormats = your DateFormats, cultureinfo is a prepared variable for shortening the code just import the namespace as below: [grafik]

[Dimple_Mandal (UIPath Explorer)]

@Yoichi

resultDateTime

Thankyou

[Dimple_Mandal (UIPath Explorer)]

Ya ,so i was expecting it to go in else condition.

[Dimple_Mandal (UIPath Explorer)]

@Yoichi

DateTime.TryParseExact(journeyDate,"dd/MM/yyyy",Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None,New DateTime)

Thankyou It worked

[Yoichi]

Hi,

FYI, if you want to use Invoke Method activity, the following will help you.

Sequence3.xaml (36.5 KB)

Regards,

[Dimple_Mandal (UIPath Explorer)]

I am new to UIPath and would love to learn new ways of coding. For sure will use this in my workflow. Thank you so much.