Linq query to Update Datatable 1000 of Date format rows as "dd-mm-yy" from "DD/MM/YYYY HH:MM:SS"

Input
Sno Start Date End Date
1 30-04-2022 7:45 10-05-2022 17:45
2 01-05-2022 9:45 11-05-2022 17:45
3 02-05-2022 0:00 12-05-2022 18:45
4 03-05-2022 7:45 13-05-2022 17:45
Output
Sno Start Date End Date
1 30-Apr-22 10-May-22
2 01-May-22 11-May-22
3 02-May-22 12-May-22
4 03-May-22 13-May-22

Hey!

Have a view on this thread

Regards,
NaNi

Hi @Aravinthan

Try the below approach

io_dt_Data.AsEnumerable.ToList.ForEach(
	Sub(row)
		row("Start Date") = CDate(row("Start Date")).ToString("dd-MMM-yy")
		row("End Date") = CDate(row("End Date")).ToString("dd-MMM-yy")
	End Sub
	)

1000Dates.xaml (5.6 KB)

1 Like

Hi @Aravinthan ,

As an alternate, Maybe you could also try the below Component :

Thank you bro for the solution it worked for all date format conversion

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.