Usa oggetto date:
codice:
if Date() < Rs("campodata") Then Response.write("style=""background-color:red""")
if dateadd("d", 7, date()) = rs("campodata") Then Response.write("style=""background-color:yellow""")