I have used add data row to copy date values and paste in other datatable using (Cdate(row(“Date”).toString).ToString(“dd/MM/yyyy”)) as I need the date in dd/MM/yyyy format.
The format in output excel shows as General.
I tried using assign activity :- dt.columns(“new_date”).datatype= GetType(DateTime) and used sort datatable activity to sort on basis of “new_date” column. But sorting is not working and datatype is not getting changed to Date format