I am trying to change the color of a label based on the number of days till a field date and am having issues and was wondering if anyone has done anything similar?
e.g.:
meetingDate = 9/13/2019
today field (by workflow) = today
calculated field (daysTill) = meetingDate - today
rule Green
daysTill >= 30 (format cell green) ! works perfectly
rule Yellow
daysTill >= 6 && <= 29 (format cell yellow) ! kills the form
rule Red
daysTill >=0 && <=5 (format cell red) ! agan kills the form
I tried just having the less than statements for both red and yellow but red will not appear. Does anyone have any advice?
