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

[LorenzoCapocci1]

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

[EmersonF]

Try using the AddDays([Your_Date];-23)

[LorenzoCapocci1]

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 · Accepted solution]

Congratulations on the solution, but I believe the correct way to use the "AddDays()" function passing the correct parameter, as shown above.

[LorenzoCapocci1]

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

[LorenzoCapocci1]

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]

Sorry, it wasn't so clear to me, I could explain the situation better, my English is not so good!

[LorenzoCapocci1]

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

[EmersonF]

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

​

[LorenzoCapocci1]

Thank you once again.... @EmersonF​