Scenario:
A total amount is £1000, the received date of the plan is 09-Mar-2022 and payment delay is 26 days.
I want to be able to look through transactions table on webpage and retrieve any transactions amount between the 09-Mar-2022 and 04-Apr-2022 due to the payment delay,in this example it would be facility fee £30, direct debit £500 and facility fee £30 dated 24th March.
How can i go about doing this?
Hi @duaine.b
Welcome to UiPath community
You could scrape the table from webpage and then filter the table using filter datatable activity using the above mentioned condition
I have a variable inception date for 09-03-2022 and variable balancing date 04-04-2022 both type datetime. when I scrape the table the value in transaction row is Thursday 24-Mar-2022, Friday 08-Apr-2022, Tuesday 19-Apr-2022, etc. how do I configure the the filter to only bring in dates between 09-03-2022 and 10-04-2022. every time i try to filter it bring up blanks data table. Any advice?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.