Data Table read date as text

Help Activities
, ,
1

Hi,

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

2

Check the Preserve format property while reading the excel file
image

4

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

image

What’s wrong with it?

5

can you share a screenshot of excel file ?

6

Sure. This is the columns :

image

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

7

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

8

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