cancel
Showing results for 
Search instead for 
Did you mean: 

actions to run RPA on specific time based on date in a cell

LorenzoCapocci1
Level 5
Hi,
RPA is set to run every day, but it will need to work on a product is it does match 23 days before a date in the file
for example the date in the file is 10/24/2021 (-23 days = 9/22/2021) and today is 6/23/2021.
because the 10th is not today, then the row will be deleted from the collection!
I suppose a calculation stage to use, but I tried different ways with no success...
basically I need a calculation to provide a result of -23 days from  Value Date, so then I can update the decision stage to see if date is equal to today's date..

Could you help?
thank you in advance



10 REPLIES 10

EmersonF
MVP
Congratulations once again for solving your problem, I'm happy to be able to help you, whenever you need it, I'll be here 😄
Sr Cons at Avanade Brazil