topic RE: Filter Collection by date in Product Forum

Filter Collection by date

AdarshKappettu — Sat, 20 Jun 2020 06:03:00 GMT

Hi,

I am importing some data from Excel into a collection. I wish to filter the collection on Entry date today. The date in the collection is in MM/dd/yyyy text format.

Kindly suggest a syntax to filter the collection.

Thank you.
Adarsh

------------------------------
Adarsh Kappettu
------------------------------

RE: Filter Collection by date

MichalSzumski — Mon, 22 Jun 2020 06:51:00 GMT

Hi,

Use object "Utility - Collection Manipulation" -> action "Filter Collection". In "Filter" input you need do use something like below:

"[Entry Date] = '"&FormatDateTime(Now(),"MM/dd/yyyy")&"'"

------------------------------
Michal Szumski
RPA developer
Rockwell Automation
Europe/Warsaw
------------------------------