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?
I am using enterprise uipath studio 2017.1.6522.