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



1 BEST ANSWER

Best Answers

EmersonF
MVP
Congratulations on the solution, but I believe the correct way to use the "AddDays()" function passing the correct parameter, as shown above.
Sr Cons at Avanade Brazil

View answer in original post

10 REPLIES 10

EmersonF
MVP
Try using the AddDays([Your_Date];-23)
Sr Cons at Avanade Brazil

LorenzoCapocci1
Level 5
Hi Team,
After sending this email I found a way to make the dates working as I needed..
I am also adding a doc with some screen shot to show what I did, if it may be of any help to anyone feel free to use as example...

If you have any comments in regards to the setup I will be happy to provide an answer for it
thank you as always

EmersonF
MVP
Congratulations on the solution, but I believe the correct way to use the "AddDays()" function passing the correct parameter, as shown above.
Sr Cons at Avanade Brazil

LorenzoCapocci1
Level 5
Thank you @EmersonF​ will follow up with your suggestion ...
thank you once again

LorenzoCapocci1
Level 5
Hi @EmersonF​Based on the below all works well, I just met with my colleague and gave me a different request but similar, basically instead of of accept the -23 days prior of a specific date, I would like to do the following , I have 2 cell A dated July 1st and Cell B Dated July 10th, The RPA should pull any product from 1st of July until 10 th of July, if today is either one of these days and all in between!
Can you help once again?
thank you in advance

EmersonF
MVP
Sorry, it wasn't so clear to me, I could explain the situation better, my English is not so good!
Sr Cons at Avanade Brazil

LorenzoCapocci1
Level 5
Hi @EmersonF​See below example hopefully It will be clear
The expression I am trying to sort is the following
 if today is equal or Between Value A and Value B I should get a true response flag
34864.png

EmersonF
MVP
Hey @LorenzoCapocci1, try it.
My Brazilian time format is dd/mm/yyyy
consider using your time format.
but with this expression it will return the flag you need
34865.png34866.png
Sr Cons at Avanade Brazil

LorenzoCapocci1
Level 5
Thank you once again.... @EmersonF34867.png