Output the current date today using LookUp Activity

How to output the current date today in this column which is “7/22/2020” using LookUp Activity in UiPath?

image

How can I solve this?

Hi Robert,
Use assign activity and assign a variable the value as follows:
datevariable=system.DateTime.Now.ToShortDateString
Now the variable will contains the system date.
Read the excel column in a data table and compare each item value with datevariable value using for loop(for each row in data table), if it matches , you can go to next row if it does not match you can overwrite value for that row. Hope this helps.

1 Like

How will I compare each value inside the For Each Row?