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. 
