rjbrynteson

I am doing some asp work for a website and i have this field called Date (from ms sql database) that has values stored in it like "mm-dd-yy". Now i want to display only those records where date is equal too or is two weeks from the current date.

right now i only do it till EOF
here is what i have right now
which is just currently giving me all the records in the table

<%do until ObjRS.eof%>
<tr>
<td width="71" height="15"></td>
</tr>
<tr>
<td colspan="3" class="main"><b><%=ObjRS("Date")%></b></td>
</tr>


<tr class="SearchResults<%=j%>">
<td><%=ObjRS("Year")%> </td>
<td width="102"><%=ObjRS("Make")%></td>
<td width="142"><%=ObjRS("Model")%></td>
</tr>
<%
ObjRS.MoveNext
i = i + 1
%>
<%loop%>

stevengs

please use code tags around your code so that is is more legible (and to preserve the indentation):

[C O D E] your code [/ C O D E]

(without spaces in CODE)

__________________
-Steven
"Is this a piece of your brain?" - Basil Fawlty

rjbrynteson

<reply> thank you so much for the help :-) </reply>

rjbrynteson

I got code to work using