Try and solve this one!!!!!

[Tomo1]

I have got a database that contains data fields, when the date becomes 5 days old the date field turns red. When I host the file over the web, the field turns red but the date does not show, Help?

[Jeff Spall]

Hi, Is this in Instant publishing? If you check the page source has it made both field and text the same colour?

I use two very simple ways of changing colours in custom cdml publishing;

This one's just an "if" which greys out lines in the search return until action is needed:

------------------

<FONT SIZE="-1" FACE="verdana,arial,geneva,sans-serif" [FMP-IF:status.cn.production]

COLOR="#999999"

[/FMP-IF]> <B>[FMP-FIELD: status]</B></FONT>

------------------

This one changes the colour of the search return line depending on status:

------------------

<TD WIDTH=50 BGCOLOR="#[fmp-field:colourfield]">

------------------

Where "colourfield" is a calculation:

Case(status="on server","66ccff", status="accepted","00cc66", status="resend","ff3300", status="new version","66ccff","ffffff")

I think there are a lot of people on the list using fields in the html to do this kind of thing....... anyone got some examples that I can steal!!

regards, Jeff