I want to write a statement that will response.write a record based on current date. My problem is that I&#039;m not sure how to write this statement out.<BR><BR>Here&#039;s what I have, so far:<BR><BR>dim oRSp<BR>Set oRSp=server.createobject("ADODB.recordset")<BR>&#0 39;sqltext = "SELECT * FROM thoughtofday WHERE sqltext = "SELECT * FROM thoughtofday WHERE Article AND Load_Date = &#039;CURRENT_DATE()&#039;"<BR><BR>-------------------------------------------------------------<BR><BR>Does anyone know why this doesn&#039;t work and can someone help me figure out how to select a record based upon my field, "Load_Date" ...<BR><BR>Thank You<BR><BR>Tortured Soul<BR>