Anyone encountered issue whereby robot reads a custom format (formatted as dd/mm/yyyy) column from excel where the date is entered incorrectly as 09/01/1900 but when read by robot it was extracted as 08/01/1900 instead? I tried to change the date also to 10/01/1900 and robot still extract as minus 1 day date.
I cannot find an explanation for this issue at all anywhere because all other dates with the correct year from the same custom column (i.e. 09/01/2020) were all extracted correctly as it is.
Is this a robot issue? Or something that just happens programmatically?
Hmm.
I haven’t come across this scenario. It’s weird… but I have seen scenarios where sometimes it doesnt extract the exact format of the date as what we see when we open excel. That’s actually due to now extracting the data with preserved format option on.
Can you do one thing, once you click on that cell which has the date in excel, can you check the value you see in the formula bar and check whether its matching with what you extracted… and whether it is matching with the value you see on the cell itself?
u can replicate that, i tested with a new excel sheet and as long as its date format in the cell, ending with year 1900 the read cell will come out with the date minus 1 day at extraction.
Yes, I have this issue. I actually did a bit extra testing and it’s any dates from excel less than 01/03/1900 for me.
01/03/1900 in excel parses from a read range datatable to 01/03/1900 in uipath
28/02/1900 in excel parses from a read range datatable to 27/02/1900 in uipath
Only thing that changes is the date in excel (all dates UK format)
I’m using UIpath 2019.10.1
Excel 2013