Highlighting two fields in a report
Hi I want to be able to highlight when a 'next call back is over due' (Green, Yellow and Red) but if an 'own call back' is checked I want this highlighted in Blue. Both functions work fine separat...
Forum Discussion
Try this:
If (
[OWN CALL BACK], "blue",
[Next call back due on]<Now(), "red",
[Next call back due on]>Now(), "green",
"yellow")
This will check for the [OWN CALL BACK] first - and show blue if it's checked (no matter what [Next call back due on] is).
Note that if [Next call back due on] is a Date/Time field - you'll almost never get the "yellow" state - since it'll only be "yellow" for a minute before it becomes "red".
If [Next call back due on] is a Date field, then you'd want to change the references to Now() to ToDate(Now()), as follows:
If (
[OWN CALL BACK], "blue",
[Next call back due on]<ToDate(Now()), "red",
[Next call back due on]>ToDate(Now()), "green",
"yellow")
If (
[OWN CALL BACK], "blue",
[Next call back due on]<Now(), "red",
[Next call back due on]>Now(), "green",
"yellow")
This will check for the [OWN CALL BACK] first - and show blue if it's checked (no matter what [Next call back due on] is).
Note that if [Next call back due on] is a Date/Time field - you'll almost never get the "yellow" state - since it'll only be "yellow" for a minute before it becomes "red".
If [Next call back due on] is a Date field, then you'd want to change the references to Now() to ToDate(Now()), as follows:
If (
[OWN CALL BACK], "blue",
[Next call back due on]<ToDate(Now()), "red",
[Next call back due on]>ToDate(Now()), "green",
"yellow")