Differences between Excel values and datatable values

Help Studio
, ,
1

Hello,

I have a question regarding the differences between the data from my excel and the data read with “Read Range”.

For example, in my Excel I have in diffferent cells the value “23/08/2022 13:14:00”.
While debugging, I noticed that those values are not read correctly (23/08/2022 13:13:59)

I will attach a few screenshots because it’s the first time I notice this issue. Maybe someone dealt with it already and found a solution.

Thanks in advance !

2

@darie.leolea
Welcome to the forum

have a look here:
:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

also with the idea to look more deep into the time info e.g. its ms