Blue Prism Product

 View Only
last person joined: 20 hours ago 

This community covers the core Blue Prism RPA product.

 Filter collection - Latest Created date

Teuta Pajaziti's profile image
Teuta Pajaziti posted 05-22-2023 12:20


Hi,

I need to filter a collection using Created date, as you can see attached above. 
I am trying filter "[Created] < '" & Now() & "'" also trying another filter "[Created] < ='" & [Date] & "'" 
"[Created] > ='" & [Date] & "'" it is not working, it is not taking the latest file created, if you have any idea how to solve i would appreciate it, thankyou in advance 

Steve Boggs's profile image
Steve Boggs posted 05-24-2023 15:24

Hi Teuta,

Have you tried working with the 'Utility - Collection Manipulation VBO' that comes bundled with Blue Prism for this? It contains a "Sort Collection" action that could potentially do what you're looking for here, with all of its actions outlined in this KB article here.

Micheal Charron's profile image
Micheal Charron posted 05-25-2023 17:17

@Teuta Pajaziti,

You can use the MAX() aggregate function, in your filter, to return the row with the latest date in a collection:

"[Created] = MAX([Created])"