Format date field using Generate Data Table activity

[Gokul001 (Gokul Balaji)]

Hi @Olivera_Kalinic

Have a look on the thread

Date Format changing after reading CSV

Hello… I have a csv file with many columns one of which is a date. The date in CSV file is in dd-MM-yyyy format. After i use a Read CSV activity the date is changed to yyyy-MM-dd format in the DataTable. And I am writing it as a merged excel (.xlsx ) file. The CSV file cell format is “Date” and after writing in Excel the cell format is “General”. I want to retain the same format as the CSV in the Excel too. Please suggest a way.

Regards
Gokul