Thanks RCristel, I'm sorry if I wasn't too descriptive with my question. I'll try to explain it better. I have a database called "Tasks" and using ASP, I call that up on a table in web page. There is a field called Date Finished to let me know that I'm done with a task, but rather then having the task that I am done with show up every time I call it, I want it to not show when the Date Finished is a week from the current date on my system. I hope that cleared things up. Below is the ASP page that I use, could you show me where to put the filter?
<html>
<body background="C:\Documents and Settings\kham\Desktop\Backgrounds\marblefaint.jpg" >
<img src="coolsilver.png">
<center><a href="index.html">Home</a>
<a href="Prison.asp">Friends Incarcerated</a></center>
<table border="1">
<tr>
<td width="312" align=center><B>Task Description</B></td>
<td width="72"align=center><B>Date Started</B></td>
<td width="72"align=center><B>Date Finished</B></td>
<td width="33"align=center><B>Dead line</B></td>
<td width="67"align=center><B>Status</B></td>
<td width="351"align=center><B>Comments/Notes</B></td>
<br>
<hr>
</tr>
<%
Dim oRSeofc
set oRSeofc=Server.CreateObject("ADODB.recordset")
oRSeofc.Open "TaskSheet", "DSN=statussheet"
oRSeofc.MoveFirst
Response.Write "<table border='1'>"
Dim PersonCounter
PersonCounter = 0
Do while NOT oRSeofc.EOF
PersonCounter =PersonCounter + 1
Response.Write "<tr><td>" & PersonCounter & "</td>"
Response.Write "<td>" & oRSeofc("Description") & "</td>"
Response.Write "<td>" & oRSeofc("Date Started") & "</td>"
Response.Write "<td>" & oRSeofc("Date Finished") & "</td>"
Response.Write "<td>" & oRSeofc("Deadline") & "</td>"
Response.Write "<td>" & oRSeofc("Status") & "</td>"
Response.Write "<td>" & oRSeofc("Comments/Notes") & "</td></tr>"
oRSeofc.MoveNext
Loop
Response.Write "</table><br>"
Response.Write PersonCounter & " Tasks in the list"
%>
</body>
</html>
