How to add years to a date in 'yyyy' format

[Palaniyappan (Forum Leader)]

Hi

@kavya.s16

[dd-MMM-yyyy, d-MMM-yy, yyyy

When it comes to multiple date array format try by passing array of date formats in Datetime ParseExact method

Refer this thread for more details on using array of date formats

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]

Cheers @kavya.s16