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

Yudhisteer_Chintaram1 (Yudhisteer Chintaram) July 16, 2021, 10:55am 2

@Hiba_B Can you help me please? I remember you helped me for this issue: Write full Date Format in Excel column - #13 by Yudhisteer_Chintaram1

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	5110	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	1468	August 21, 2020
I want to put a date in the column from uipath Activities datatable , excel , activities , studio , reframework , question	5	2247	December 29, 2021

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Convert Column to DateTime Format after Merging

Related Topics