Topic Thread

Expand all | Collapse all

Filter Collection by date

  • 1.  Filter Collection by date

    Posted 06-20-2020 07:03
    ​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
    ------------------------------


  • 2.  RE: Filter Collection by date

    Posted 06-22-2020 07:51
    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
    ------------------------------