cancel
Showing results for 
Search instead for 
Did you mean: 

Filter collection - Latest Created date

TeutaPajaziti
Level 2

35611.png
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 

2 REPLIES 2

SteveBoggs
Staff
Staff

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.

MichealCharron
Level 7

@TeutaPajaziti

"[Created] = MAX([Created])"
Micheal Charron
RBC
Toronto, Ontario
Canada