<Urgent> How to make a selector a variable so that it can only click on the particular date value only?

[anjasing (Anjali)]

I want to process data of yesterday’s date that I have already extracted in excel file. But I’ve to click on the table present in SAP system but the value gets refreshed every time? So bot clicks the recent name instead of clicking the yesterday’s date variant? So if anybody can help on this??art for further

for e.g. today’s date is 29 but i want to process yest date (28)
So i want to process 28th date. But getting ABC in today also so bot is performing action on today’s abc not 28th ABC
Please help

[jack.chan]

you can insert variable into selector like this
e.g. if variable = dateToClick
you type {{dateToClick}} in your selector

if you want to click yesterdays date, then before click activity, assign dateToClick = now.AddDays(-1).ToString("ddMMyyyy")

[anjasing (Anjali)]

Hi, I have updated the image of excel i am extracting…these are variables in first columns I need to click for yesterday’s date

[jack.chan]

can you filter your datatable so that its only yesterdays date first?

do you have screenshot of what youre trying to click/?

[anjasing (Anjali)]

It’s looking like the same mentioned in image of excel here.

[anjasing (Anjali)]

Update >> Hey guys, thank you so much. The issue gets resolved.

[anjasing (Anjali)]

Hey! Thanks for suggesting this…I tried contacting application SME and it’s sorted! Thank you so much