Date format in

In first excelsheet, one column( contains Date ) which has format 22 nov 2019.
i want to copy this dates to another with date format 22.07.2019
how to do this?

Hope these steps would help you
— use excel application scope and pass the file path as input
— use read range activity and get the output with a variable of type datatable named outdt
— the use a for each row loop and pass the above variable as input
— inside use a assign activity and mention like this
Out_datestr = DateTime.Parseexaxt(row(“yourcolumnname”).ToString.Substribg(0,10),System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Cheers @Aru