I have a pruchasing DB and I am trying to change the date on a page to display Red if it is within 10 days of the current date, i am really struggling with it. Here is my code, does anyone know a simple way of doing it. It pulls the date from a SQL DB.

<%if RS("requested_s hip_date")<>"" then%>
Project or store opening equipment due date<br>
<input type="text"...