Data Table read date as text


I have a column contains date (example 20/7/2022) and when I try to convert it into yyyy/MM/dd it shows an error. After I show the value using writeline, the date becomes random number (44752). How to fix this? My data in the excel file is already set to date format

Check the Preserve format property while reading the excel file

Wait it’s not working… I got this error now after check the PreserveFormat :


What’s wrong with it?

can you share a screenshot of excel file ?

Sure. This is the columns :


I tried with numerics, and letters and it’s not working.

I got it solved. I have to use the modern activities (UiPath.Excel.Activities) instead of classic read range.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.