topic RE: Filter Collection with dates in University Forum

Filter Collection with dates

Sudha_RPA — Thu, 07 Mar 2024 12:12:00 GMT

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 — Thu, 07 Mar 2024 15:32:00 GMT

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 — Thu, 07 Mar 2024 15:33:00 GMT

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
------------------------------