Hi All: I am trying to build a robot that find each row with specific title,
Below is the excel sheet I am working on,
I found a robot that is able to return the value for column “status”
But what about I want to use the specific date instead of the “status”?
For example the tile of the column is “8/1/2020” in stead of the “status”
And because I only want to read the value for current date, so I assign a variable currentdate=DateTime.now.ToString(“M/01/yyyy”)
But for the “If” activity, after I change the “status” to the variable_currentdate as below, then it never recognize(never return me the value),
Could you please teach me how to let this robot to give value when the title of the column changed from “status” to a variable, currentdate?