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

[Aravinthan]

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

[THIRU_NANI (NaNi)]

Hey!

Have a view on this thread

How to modify / change / update or replace value as date in data table cell using LINQ?

Hi, I need to modify the date values in columns I and J. [image] In column I = Date1, I want to change the cell from the date format "MM/dd/yyyy HH:mm:ss" to the format "dd-MM-yyyy HH:mm:ss" In column J = Date2 I want to change the cell from the date format "MM/dd/yyyy HH:mm:ss" to the format "dd-MM-yyyy" I’d like to make changes without using a loop through the data table. I think the use of LINQ will be appropriate. Can someone proficient in LINQ help me? Sample data: Place RMS Ag…

Regards,
NaNi

[kumar.varun2 (Varun Kumar)]

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
	)

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

1000Dates.xaml (5.6 KB)

[supermanPunch (Arpan)]

Hi @Aravinthan ,

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

Novigo Solutions - DataTable Date Formatter - RPA Component | UiPath Marketplace

[Aravinthan]

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