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

amrit_verma · June 8, 2018, 10:08pm

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

AshwinS2 · June 9, 2018, 4:20am

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

amrit_verma · June 9, 2018, 8:40am

Thanks Ashwin S

Topic		Replies	Views
Date Format changing after reading CSV Help studio	24	7278	October 29, 2019
Date Format changed after reading the excel Studio excel , studio	1	879	July 16, 2020
Date format in DataTable Activities excel , activities , question	6	754	October 8, 2022
How to make the Date format correct in Excel? Studio excel , question	0	784	April 15, 2020
Date Format changed in CSV StudioX studiox , question	7	1695	September 29, 2021