topic RE: Blue Prism Filter Collection in Product Forum

Blue Prism Filter Collection

Digital_WorkerB — Thu, 26 Nov 2020 09:00:00 GMT

I am having issues around [Utility - Collection Manipulation - Filter Collection] I have a Get Files action which gets all the files from a particular folder and outputs them into a collection in Blue Prism (there are 14 .txt files) I then use the Filter Collection Object to filter this folder "Files" I am trying to only bring back results in the collection for where the "Created" (DateTime) = today or yesterdays date.

Date1( DateTime) FormatDateTime(Today()&" "&LocalTime(),"dd/MM/yyyy") Date2(DateTime) FormatDateTime(DateAdd("9", "-2", Today())&" "&LocalTime(),"dd/MM/yyyy")

Filter Expression : "[Created] <= "&"'" &[Date1]&"' and [Created] >= "&"'" &[Date2]&"'"

There is no Error message and it doesn't output any results. I am thinking that maybe Date1 and Date2 aren't being read as dates perhaps?

Any help on this matter would be greatly appreciated.

Regards,

Gary

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Gary.

RE: Blue Prism Filter Collection

TobiasArnold — Thu, 26 Nov 2020 11:57:00 GMT

Hi Gary,

The VBO uses the DataTable.Select method from .NET. To use Date-Values in filter, you need a special syntax. Surround the dates by '#'-signs.
Here are a few examples https://www.csharp-examples.net/dataview-rowfilter/

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

RE: Blue Prism Filter Collection

PvD_SE — Mon, 30 Nov 2020 11:07:00 GMT

Duplicate with: "Is there a way to filter a folder by dates Blue Prism"

------------------------------
Happy coding!
Paul
Sweden
------------------------------