Data Conversion

I want to see if I can create a slick query to do this and cut down on some code. I have a list of dates & statuses like this: 01/05/08 Complete 02/15/09 Complete 02/18/08 Active 05/10/08 Cancelled 06/07/08 Pending 02/19/08 Complete I'll order them in the query. What I need to do is first check to see