How to handle date format while reading the Excel file as it keeps on changing?


#1

How to handle date format while reading the Excel file as it keeps on changing in the excel?


#2

Hi @amrit_verma

Check the below post

(or)

based on datatable you can change the value with assign activity as Convert.toDateTime(“DD/MM/YYYY”).toShortDateTimeString

Thanks
Ashwin S


#3

Thanks Ashwin S