topic Re: filter collection - latest created date in Product Forum

filter collection - latest created date

TeutaPajazitiMerovci — Mon, 22 May 2023 11:10:49 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

BenoitCayla — Mon, 22 May 2023 11:16:50 GMT

Hi Teuta,
Unfortunately this is the wrong community, can you post your question in the "Blue Prism RPA Product" (that should be thr right one) instead?
Many thanks.

Re: filter collection - latest created date

MikeRamore — Tue, 23 May 2023 15:34:44 GMT

You can try using the <code>DATEDIFF</code> function to compare the created date to the current date. This would allow you to filter the collection using a condition like this: <code>[Created] >= DATEDIFF(Now(), [Date], 'd') </code> Here, the 'd' parameter in DATEDIFF specifies the day unit for the comparison. The final step is to monetize your video streaming website. You can do this by offering subscription plans to users, placing ads on your website, and using affiliate marketing. You can also use pay-per-view options for special events or content

https://mlsdev.com/blog/how-to-create-a-video-streaming-website.

Re: filter collection - latest created date

Soumya21 — Mon, 28 Aug 2023 03:24:58 GMT

Hi,

Try to use sort collection action of collection manipulation VBO

Try to Sort the Created Column

Re: filter collection - latest created date

DevendranVenkatesh — Fri, 08 Sep 2023 12:56:30 GMT

Use sort collection function . For immediate help please post your questions in “Blue Prism RPA Product" community