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 ?