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

[ppr (Peter Preuss)]

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]