CaryC
Canvas Initiate

form formatting rule date range

Jump to solution

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?

0 Kudos
Reply
2 Replies
sojanm
Workflow Veteran

Re: form formatting rule date range

Jump to solution

I think you should use
daysTill >= 6 && daysTill <= 29
daysTill >=0 && daysTill <=5

View solution in original post

0 Kudos
Reply
CaryC
Canvas Initiate

Re: form formatting rule date range

Jump to solution
Awesome works perfectly! THANKS!
0 Kudos
Reply