topic This worked for me: BO - … in Product Forum https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62277#M15420 This worked for me: BO - 'Collection Manipulation' Action - 'Filter Collection' ______________________ Collection In : your collection with dates Filter : ""date < '"" & ToDate(FormatDate(Today(), ""MM/dd/yyyy"")) & ""'"" (date = column name)   Fri, 17 Aug 2018 16:50:00 GMT JiriPospisil 2018-08-17T16:50:00Z Filter using date https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62276#M15419 In Blueprism, how to use filter query for a collection have value as date like dd.mm.yyyy? e,g I want all dates that are less than today Fri, 17 Aug 2018 12:47:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62276#M15419 RupanjalBhowmi1 2018-08-17T12:47:00Z This worked for me: BO - … https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62277#M15420 This worked for me: BO - 'Collection Manipulation' Action - 'Filter Collection' ______________________ Collection In : your collection with dates Filter : ""date < '"" & ToDate(FormatDate(Today(), ""MM/dd/yyyy"")) & ""'"" (date = column name)   Fri, 17 Aug 2018 16:50:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62277#M15420 JiriPospisil 2018-08-17T16:50:00Z Maybe you'll need to play… https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62278#M15421 Maybe you'll need to play with formatting a bit, I just created some custom collection and it took system format (in your case it might be ""dd.MM.yyyy"" instead). Fri, 17 Aug 2018 16:59:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-using-date/m-p/62278#M15421 JiriPospisil 2018-08-17T16:59:00Z