Currently im developing a process of where i need to get specific row values that contained the date variable i assigned inside the column as in the picture.
DateVar1 = datetime.Now.AddDays(1)
DateVar2 = datetime.Now.AddDays(2)
I have check the format of the excel column values. But it does not have any specific format ie;General,date,Number. Nor of that fromat represent on the values contained in this specific column.
I have also tried to actually display all the values using message box. And seems like it is in string format.
And as for that, i have convert the date variable to string format (“MM/dd/yyyy”) as that is what shown in the message box.
But when i try to filter out that specific values there is no values capture except the headers of each column only.
Please help me, as im still new in Uipath and RPA. Attached are the screenshot of the table itself.