Multiple Layered Fields

[Tomo1]

Is it possible to have a Date field, but behind have a coloured calculation field. So when the date becomes so many days old, the coloured field would show through and the date would appear, say red. I know this is very vague but it's hard to explain?

[BobWeaver]

Make a global container field called "Red", and paste a red rectangle into it. Then create a calculation field BkgndColor with the following formula:

case(Status(CurrentDate)-DateField>5,Red,"")

The result of this calculation should be set to Container.

Then place this field behind your date field. Make sure that the date field is transparent. Now, if the date is more than 5 days old, the background will change to red.

[Tomo1]

Thanks for your reply, I have already got the colour to change when the date is overdure by 5 days and Difined the fields as you stated, but the trouble I can't get the date field to be transparent. They just Block each other out. ie: you can only have either the date showing or the red?

[LiveOak]

Two things: Make sure the date field has a fill of transparent and make sure the date field is in front (arrange, bring to front). -bd

[Tomo1]

I have now solved the problem. In table view, there is no way to put fields behind each other, they always display next to each other.

Thanks for all your help.

[Tomo1]

Is there anyway for the colours to work ok when the file is hosted over the web.