Null/Blank date shows 01/01/0001

Hi,
Please i need help resolving this: If there is a value it shows the date however, if there is no value, it shows 01/01/0001 as in the attachment below. I would appreciate any form of help.

I just want it to be blank if it is null or empty

image

Hi @Ayodeji_Osikoya
Can you share your input file

@Ayodeji_Osikoya

Can you give more inputs?

Is the column is in Date format? Also is it written back from UiPath using write range and you are facing this issue?

Thanks

it was in data format. i changed it to string and it worked

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.