cancel
Showing results for 
Search instead for 
Did you mean: 

Filter using date

RupanjalBhowmi1
Level 2
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
2 REPLIES 2

JiriPospisil
Level 4
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
Level 4
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).