ASP.NET Forum

**ComputerCon** · 04:09 PM

I have a task table with a field called Date Finished, and I want to know how I can filter this field so that the row that the data it is in doesn't show on my web page if the task has been done for one week after the date the task was finished, I want it to not show, or something like that. I hope you understand my question.

Please help, it is important that I get this done, ASAP.

**rcristel** · 03-11-2005, 01:49 PM

I'm not sure I understand the question completely, but perhaps you can include something like the following in your SQL statement to filter out the tasks that have been finished a week ago or longer:

WHERE [Date Finished] <= dateadd("d",-7,getdate())

If you have Null values for the [Date Finished] field you may also have to include ....
... OR [Date Finished] IS NULL

Hope this helps

**reload2** · 03-13-2005, 04:50 AM

Quote:

Originally Posted by rcristel

I'm not sure I understand the question completely, but perhaps you can include something like the following in your SQL statement to filter out the tasks that have been finished a week ago or longer:

WHERE [Date Finished] <= dateadd("d",-7,getdate())

If you have Null values for the [Date Finished] field you may also have to include ....
... OR [Date Finished] IS NULL

Hope this helps

Hey, I also was looking for something like that for some time! Thanks.

**ComputerCon** · 03-22-2005, 01:25 PM

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>