Hi, I have to merge 2 excel files. My merging process is correct however it is not merging my columns with dates value correctly. Before merging: [image] After merging: [image] When I change my column type to DateTime in excel it works. But is there a way to do it with the UiPath itself? Th…

@Yudhisteer_Chintaram1 - Could you please try this… dtdate.AsEnumerable().ToList().ForEach(Sub(row) row("ASN Shipment Date")=Datetime.ParseExact(Datetime.FromOADate(cdbl(row("ASN Shipment Date"))).ToString("dd/MM/yyyy"),"dd/MM/yyyy",CultureInfo.InvariantCulture)) For me this is giving the output …

Convert Column to DateTime Format after Merging

Help Activities

balupad14 (Balamurugan) July 16, 2021, 11:30am 3

Hi @Yudhisteer_Chintaram1 ,

Please a look at this one.

Thank you
Balamurugan.S

1 Like

Topic		Replies	Views
Issue when merging datatables Studio datatable , excel , activities , studio , question , tools	6	694	June 30, 2021
Change the DateTime column in to string column in Excel Help excel , activities	4	5109	November 14, 2017
How to Convert a excel column to date time format Activities excel , activities , question	2	493	January 27, 2023
Format or value of excel data changes Help	3	1467	August 21, 2020
I want to put a date in the column from uipath Activities datatable , excel , activities , studio , reframework , question	5	2244	December 29, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Convert Column to DateTime Format after Merging

Related Topics