Filter Collection by date

[AdarshKappettu]

​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
------------------------------

[MichalSzumski]

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
------------------------------