cosi me lo fa
<%
CountdownDate = (Recordset1.Fields.Item("SCADENZA").Value)
If Date >= CountdownDate Then
Response.Write "mancano!"
Response.End
End If

theDate = Now
DaysLeft = DateDiff("d",theDate,CountdownDate) - 1
theDate = DateAdd("d",DaysLeft,theDate)
HoursLeft = DateDiff("h",theDate,CountdownDate) - 1
theDate = DateAdd("h",HoursLeft,theDate)
MinutesLeft = DateDiff("n",theDate,CountdownDate) - 1
theDate = DateAdd("n",MinutesLeft,theDate)
SecondsLeft = DateDiff("s",theDate,CountdownDate) - 1
%>
mi aiti con la sintassi per far si che quando date e' > contdowndate mi elimini il record
ho scitto cosi ma va ridere..
<%
CountdownDate = (Recordset1.Fields.Item("SCADENZA").Value)
If Date >= CountdownDate Then
DELETE * FROM [OGGETTI IN VENDITA] WHERECountdownDate < now()
Response.End
End If

theDate = Now
DaysLeft = DateDiff("d",theDate,CountdownDate) - 1
theDate = DateAdd("d",DaysLeft,theDate)
HoursLeft = DateDiff("h",theDate,CountdownDate) - 1
theDate = DateAdd("h",HoursLeft,theDate)
MinutesLeft = DateDiff("n",theDate,CountdownDate) - 1
theDate = DateAdd("n",MinutesLeft,theDate)
SecondsLeft = DateDiff("s",theDate,CountdownDate) - 1
%>
ovviamente sbagliato