Filter Collection with dates

[Sudha_RPA]

Hi All,

How to filter collection for particular date interval(ie. 03/04/2024 to 03/08/2024)

Regards,

Sudha

------------------------------
Sudha Priya
------------------------------

[Dexter_Whelan_SAS · Accepted solution]

Hi Sudha.

Think you're looking for something like the filter collection action inside of collection manipulation.

the syntax is basically [filter name] = 'some value' to get what you want. 

here is an example

top level view

each stage

(this is a custom object but the action exists in the normal collection manipulation)

note the query syntax. 

inside the single quotes I have hardcoded a value but you may want to use a variable which would be like this:

result post filter inside another collection that you can then use. if no values are found the collection will contain zero rows

thanks 

Dexter

------------------------------
Dexter Whelan
Senior Developer/Mentor
SAS
Europe/London
------------------------------

[LeonardoSQueiroz]

Hello,

There are a few different ways to carry out the process.

In this article there are some suggestions: Filtering a collection by date

 Regards,

------------------------------
Leonardo Soares
RPA Developer
América/Brazil
------------------------------