Hi Gurus,
I currently have a collection ~2000 Rows. there is Col1 (text) = 6/07/2019 17:03.
Now I need to filter out all ROWS from the collection where the dates has PAST (i.e Past dates)
my excel formula was simple "=IF(Col1<NOW(), "Past","Still Time") = only need PAST"
If anyone can help guide me to how to do this using 1. "Data - OLEDB - Get Collection" - what would my SQL query be?
or by using Utility Collection Manipulation - Filter Collection. What would my Filter text be?
Really appreciate your help, i'm not confident in using dates in BP yet.
I currently have a collection ~2000 Rows. there is Col1 (text) = 6/07/2019 17:03.
Now I need to filter out all ROWS from the collection where the dates has PAST (i.e Past dates)
my excel formula was simple "=IF(Col1<NOW(), "Past","Still Time") = only need PAST"
If anyone can help guide me to how to do this using 1. "Data - OLEDB - Get Collection" - what would my SQL query be?
or by using Utility Collection Manipulation - Filter Collection. What would my Filter text be?
Really appreciate your help, i'm not confident in using dates in BP yet.