Filter using date

[RupanjalBhowmi1]

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

[JiriPospisil]

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)  

[JiriPospisil]

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