How to convert different kind of dates in a data table to one format uipath

[sheeraz.areeb]

Hi I have 5 to 6 different formats of dates like (eg, 12-10-2021, 11-Sep, 2021/07/11 ) in datatable i want to change it into one format without using for each activity because i have huge data set over 90000 so i dont want to use for each loop.

[Palaniyappan (Forum Leader)]

Hi

Welcome to UiPath forum

Have a view on this thread for more ideas

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

Hi @BalaM1510, Welcome to the Forum you can try this way Do the Linq query part and take the result you will eventually use that result right. When you using the result do the Date Conversion part using DateTime.Parse method As my understanding you cant directly do the update part

Cheers @sheeraz.areeb