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?
meetingDate = 9/13/2019
today field (by workflow) = today
calculated field (daysTill) = meetingDate - today
daysTill >= 30 (format cell green) ! works perfectly
daysTill >= 6 && <= 29 (format cell yellow) ! kills the form
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?
Solved! Go to Solution.