Problem with date comparision in asp

I have code like this where i need to display the records valid till yesterday
I am getting error can u please
I wnat to disply the records who date is equal or before today

<%str=date()
                set rsspl=server.CreateObject("adodb.recordset")
                rsspl.Open "select resid from tbl_onlinespecialmaster group by resid where enddate < "&str&" ",con,3,3
                'if
                do while not rsspl.EOF
               %>
                <%set rsname=server.CreateObject("adodb.recordset")
                rsname.open "select resname from tbl_restaurantmaster where resid="&rsspl("resid")&"",con,3,3
                %>
                <b><font class=pagetext>
                <a href="http://<%=ipadd1%>/resdetail.asp?resid=<%=rsspl("resid")%>" class=full><%=rsname("resname")%></a>
                </font></b>
                <%set rscuisine=server.CreateObject("adodb.recordset")
                rscuisine.Open "select cuisine from tbl_rescuisine where resid="&rsspl("resid")&"",con,3,3
                do until rscuisine.EOF%>
                <font class=pagetext><%=rscuisine("cuisine")%>
                <%rscuisine.MoveNext
                loop
                rscuisine.Close
                set rscuisine=nothing
                %>