i need your support for the display logic in Case list
I have configured If next visit has been crossed last check list date the icon should be RED
today() > date(. + 30)
If next visit date is one or 30 more days away from last checklist date then icon should be GREEN
today() < date(. + 30)
now i want case list shows Yellow icon if next visit date is 15 days remaining (out of 30 days) but i am not able to make it.
Kindly help me on that
Note: Above two logics are working perfectly.
Thanks in advance for your support