Why does excel field which is supposed to be Date returns negative values in weird format in UiPath?

Hello all,

It’s probably the sixth time I’m asking for dates format, but the struggle is real.

So, the situation is the following:
In the excel file, column Date Time looks like this:

As you can see, the format in the field is 26:02.9, but when you select that field, in the textbox above result is 12:26:03 AM.

When I extract the value from the row in UiPath, the result from the field is: 0.0180891203703704

People advised me to convert that field using DateTime.FromOADate(Convert.ToDouble(row(“Date Time”))).ToString
When I do this, I’m getting the following date: 12/30/1899 00:26:02

I know the Date isn’t good because it cannot be 1899 in my use case.

What am I doing wrong and how could I fix that?
Thanks in advance. :raised_hands:

Hi @bp777 !

Would you mind sending us this column as an excel file so we could look into it together ?
Also, what is the format date you use ? French ? American ? Other ?

have a look here:

Of course.

dates.xlsx (22.1 KB)