Filter Excel column from next 3 days upto coming 365 days (Cannot use Collection)

[AsitabhaDeb]

Hi Experts,

I have excel file with date column. Now my requirement is I would like to filter the date column from next 3 days up to coming 2-3 years.
I cannot use Collection because my excel file consist 51k data and at the end I need to write collection which is taking long time compare to the manually completion of this process.

For e.g :     Column Name
                   CRD
                    2019
                    2020
                    2021

It will take date from 05.11.2020 (filter out previous month) up to 2022 include all the month and filter out 2019. 
I have posted lots of message in this section. Thanks all of you who had helped me.
Please help me to solve this issue.




------------------------------
Asitabha Deb
------------------------------

[AshishEasow]

Hi Asitabha,

have you tried OLE DB with the required date fields in where clause and with select in batches for performance.

regards

------------------------------
Ashish Easow
Senior Consultant - Professional Services
Blueprism
Asia/Kolkata
------------------------------