Covert column in specific date format

[pradeep931 (Pradeep Bandharam)]

Hi @Lakshya_Garg2

Please refer the below thread

Is it possible to convert a column format date MM/dd/yyyy to dd/MM/yyyy faster

Hi Yeah it can be with this expression stroutput = Datetime.ParseExact(Strinput.ToString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”) And while merging make sure you have both the datatable having dates in same format and when written to excel it actually changes the format To avoid that use a for each row activity and pass datatable dt as input Inside the loop use a assign activity like this CurrentRow(“date ColumnName”) = “ ‘ “+ CurrentRow(“da…