Skip to Content
avatar image
Former Member

How to add multiple font colors on date fields (i.e. expiring and exp soon)

I want a staff report to show items that have expired and those reports that are about to expire. For example:

if PLAN.END_DATE has expired/passed (based on current date/today), make red and/or

if PLAN.END_DATE is within 60 days or less (based on current date/today), make purple

How would I do this on Format Field > Font > Font Color X-2 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 26, 2014 at 07:22 PM

    Use an IF or Case statement and a Color() or RGB() function.

    Add comment
    10|10000 characters needed characters exceeded