How to output the current date today in this column which is “7/22/2020” using LookUp Activity in UiPath?
How can I solve this?
How to output the current date today in this column which is “7/22/2020” using LookUp Activity in UiPath?
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.