I have a datatable DT with column date in the form like 20200101 and I would like to convert it to 01-01-2020 for the column.
I used the below expression in Assign:
row(“Reception Date”)= Datetime.ParseExact(row(“Reception date”).ToString,“dd-MM-yyyy”,System.Globalization.CultureInfo.InvariantCulture)
I am getting below error:
String was not recognized as a valid DateTime.
Does anyone have a better solution for it?