topic Filter collection - Latest Created date in Product Forum

Filter collection - Latest Created date

TeutaPajazitiMerovci — Mon, 22 May 2023 11:20:23 GMT

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

Re: Filter collection - Latest Created date

steven.boggs — Wed, 24 May 2023 14:22:56 GMT

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.

Re: Filter collection - Latest Created date

MichealCharron — Thu, 25 May 2023 16:15:02 GMT

@TeutaPajazitiMerovci

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