Read Range returns error 'OleAut Date' when there is '00/01/1900 00:00' date format

Hello guys, I’m getting an error while trying to read an excel file with a column with “00/01/1900 00:00” as date type.

I’m trying to bypass this error since I cannot change nothing in this column at principle.

image

image

@Leonardo_Andrade

Try changing the properties of read range to read the display value

Cheers

Hey @Anil_G, thanks for your help. I didn’t get the error when I changed to ‘Display Value’, but it takes too much time to read now.

@Leonardo_Andrade

Try with workbook read range and display value…that might reduce some time…

Display value moght take time as it tries to convert as per formatting and then read… as the raw format looks wrong this the way that we need to try

Cheers