topic Re: actions to run RPA on specific time based on date in a cell in Product Forum

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

LorenzoCapocci1 — Wed, 23 Jun 2021 18:08:20 GMT

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

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

EmersonF — Wed, 23 Jun 2021 19:46:25 GMT

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

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

LorenzoCapocci1 — Wed, 23 Jun 2021 19:47:40 GMT

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

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

EmersonF — Wed, 23 Jun 2021 19:55:48 GMT

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

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

LorenzoCapocci1 — Wed, 23 Jun 2021 20:00:57 GMT

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

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

LorenzoCapocci1 — Tue, 29 Jun 2021 10:37:39 GMT

Hi @EmersonFBased 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

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

EmersonF — Tue, 29 Jun 2021 14:20:30 GMT

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

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

LorenzoCapocci1 — Wed, 30 Jun 2021 15:34:41 GMT

Hi @EmersonFSee 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

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

EmersonF — Wed, 30 Jun 2021 16:32:35 GMT

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

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

LorenzoCapocci1 — Wed, 30 Jun 2021 18:27:54 GMT

Thank you once again.... @EmersonF

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

EmersonF — Wed, 30 Jun 2021 18:32:12 GMT

Congratulations once again for solving your problem, I'm happy to be able to help you, whenever you need it, I'll be here 😄