change text color

PS
Let me try that post w/ line breaks

Use the Date Diff function

See - http://www.devguru.com/technologies/vbscript/quickref/datediff.html

In the cell displaying your date find the DBRW result code for the date display from the DB

- say it is: <%=fp_rs("yourdatefieldname")%>

Replace it with:

<% If DateDiff("d",Date(),fp_rs("yourdatefieldname"))>30 then %>

<font color"red"><%=fp_rs("yourdatefieldname")%></font>

<% Else %>

<font color"black"><%=fp_rs("yourdatefieldname")%></font>

<% End If %>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"Stefan B Rusynko" <sbr_enjoy.RemoveThis@hotmail.com> wrote in message news:u7kIAVrKJHA.1500@TK2MSFTNGP06.phx.gbl...
| Use the Date Diff functionSee - http://www.devguru.com/technologies/vbscript/quickref/datediff.htmlIn the cell displaying your
date
| find the DBRW result code for thw date display from the DB- say it is: <%=fp_rs("yourdatefieldname")%> Replace it with:<% If
| DateDiff("d",Date(),fp_rs("yourdatefieldname"))>30 then %> <font color"red"><%=fp_rs("yourdatefieldname")%></font><% Else %>
| <font color"black"><%=fp_rs("yourdatefieldname")%></font><% End If %>
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
| "Mary Ann Hailey" <MaryAnnHailey.RemoveThis@discussions.microsoft.com> wrote in message
| news:6DBCD5A2-7361-436A-BED8-FAF0FE753001@microsoft.com...
||I have a database results page that pulls a maintenance schedule from a query
|| in MS Access. The users would like to see the past due items highlighted. How
|| do I do this? Thank you!
|
|