Topic Thread

Expand all | Collapse all

Filter Collection by date

  • 1.  Filter Collection by date

    Posted 06-20-2020 07:03

    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 Kappettu

  • 2.  RE: Filter Collection by date

    Posted 06-22-2020 07:51

    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