RohitDangi
New Member
Hi Team,
In my process, I stored the data from excel into a collection using 'Get Worksheet As Collection'. In the excel there is column with name 'Date' in which values are of format 'DD/MM/YYYY'. And values in the 'Date' column can be of any month and year i.e approx 5000 records. Now i have to filter out the data based on the condition.
Condition. Let us assume my process run on every Monday in a month.
( Current Monday - 3 days)<= Date >= 01/(Current month)/ Year i.e values must be between '1 day of the running process month' and last Friday corresponding to the Monday on which it is running.
Please help me how to use the filter collection.
In my process, I stored the data from excel into a collection using 'Get Worksheet As Collection'. In the excel there is column with name 'Date' in which values are of format 'DD/MM/YYYY'. And values in the 'Date' column can be of any month and year i.e approx 5000 records. Now i have to filter out the data based on the condition.
Condition. Let us assume my process run on every Monday in a month.
( Current Monday - 3 days)<= Date >= 01/(Current month)/ Year i.e values must be between '1 day of the running process month' and last Friday corresponding to the Monday on which it is running.
Please help me how to use the filter collection.