Change color of field in report based on value

Question

I have a Formula-Duration field that shows the number of days since the record was created.

roughly the formula is Today - ToDate([Date Created])

I would like to color code the value in the report so that 'old' durations are in, say Red, while middle age records are Yellow txt and new/current records (say < 30 days old) are either Green or Black.

I was also considering using the report color coding but Formula - Duration isn't an eligible field type.

------------------------------
Katherine Oakey
------------------------------

MarkShnierYou · Answer

Try thisvar number DaysOld = ToDays(Today() - ToDate([Date Created]));IF($DaysOld < 30, "#00FF00" // green$DaysOld < 45, "yellow",$Days Old >=45, "Pink")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community