I want to copy date from one column of excel sheet and paste into another column of excel sheet. The original date is"13-Jan-21" format required format is “JAN-13”. and this change has to apply for entire column. I tried PO_date = DateTime.ParseExact(gtdate,“dd-MMM-yy”,System.Globalization.CultureI…

Hi @Kanchan_Gawande To do the entire column, you have applied like this. [image] Thank you @Sudharsan_Ka Regards Balamurugan.s

How to change date in right format for column of excel using uipath

balupad14 (Balamurugan) January 15, 2022, 2:20pm 6

To do the entire column, you have applied like this.

Regards
Balamurugan.s

1 Like

Check format of date in datatable

Topic		Replies	Views
Copy date from Excel and Paste with uipath Help	2	2615	March 13, 2018
Formatting date column Studio	12	1070	May 23, 2022
Change Date format in excel Academy Feedback excel , activities	0	656	April 25, 2020
I want to put a date in the column from uipath Activities datatable , excel , activities , studio , reframework , question	5	2246	December 29, 2021
Date format question Studio	12	1910	January 13, 2022