Exception handling in date formats

[Sakshi_Jain]

how to capture two similar types of exception in one case ?
I need to convert date into dd/mm/yyyy format
current date can be in dd.MM.yyyy or dd.M.yyyy
(Datetime.ParseExact(Input_VAR_Date.ToString,“dd/mm/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

[zwils0 (Elizabeth Wilson)]

Are you saying that the date could be 10.01.2021 or 10.1.2021?

If yes you could try

Date.Parse(Input_VAR_Date.ToString)

[ppr (Peter Preuss)]

How to Convert multiple column date format in data table using linq(With out foreach)

@BalaM1510 the main building block is an array with formats: [grafik] which can be used DateTime.ParseExact(YourDateString, arrFormats, YourCultureInfo, DateTimeStyles.None) from your question it can be derived: a column with date strings is the input for a dateTime.ParseExact the conversion result will update the value within the column LINQ could be used for this. But as we have to be prepared for conversion fails LINQ is less helfull for this due: ALL or Nothing is converted intran…

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]