sending data to asp page based on date

I have a table in SQL Server that has 3 rows, LineID, Information, and Expires. It's for a Church calendar and they want to input the data in bulk for different dates. The Expires is the last date they want to info to show. If today's date is 07/27/2004 and there is a record like LineID - 7, Information - Field Trip, and Expires - 07/26/2004, than it should not be seen today. But, if there is a record like LineID - 8, Information - Teacher Inservice, and Expires - 07/28/2004, then it should be seen as long as 07/28/2004 is <= today's date. Basically as soon as the Expires value is greater than today's date the Information can't be viewed, but the Information with the highest Expires value that is less than today's date is the one that is seen by the users. I've written several scripts that "in my mind" should work... but...

well, i guess i need help with either someone telling me what's wrong with my script or showing me a better way. here's mine...
Set rstMercy = Server.CreateObject("ADODB.Recordset")
strSQL1 = "SELECT Max(LineID) " _
& "AS MaxID From DatedMaterial WHERE " _
& "ViewUntil <= '" & CurrentDateTime & "'"
rstMercy.Open strSQL1, connStr
Set rstMercy2 = Server.CreateObject("ADODB.Recordset")
strSQL2 = "SELECT * FROM DatedMaterial WHERE " _
& "LineID = '" & rstMercy("MaxID") & "'"
rstMercy2.Open strSQL2, connStr

I really appreciate the info. After tweaking your suggestion a bit everything works great now. These forums are a great resource.