on 12-26-2014 7:12 PM
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 ?
Use an IF or Case statement and a Color() or RGB() function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ido Millet wrote:
Select Today
case is < #1/1/2015# : crRed
Case #1/2/2015# : crpurple
Case is > #1/2/2015# : crblue
default: crBlack ;
Thank you . However, I was hoping for a more dynamic way of specifying this without static dates. I tried removing the dates+hash and replacing with CurrentDate or Today, and it just made everything purple.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.