Help with conditional format using > and <
having trouble with the greater than or less than in this conditional to change field fill color.
IsEmpty ( Evaluation::Date_closed_manager ) and ( ( evaluation::date current - Evaluation::contract_date_received ) ≥ 3 ) and ( ( evaluation::date current - Evaluation::contract_date_received ) ≤ 6 )
You might use the let function to simplify this:
let ( days = evaluation::date current - Evaluation::contract_date_received ; IsEmpty ( Evaluation::Date_closed_manager ) and ( days ≥ 3 ) and ( days ≤ 6 ) ) // end let
I have another conditional on this field stating if it is equal to or greater than 7 to turn red. However the one above works to turn yellow but the second one to turn it to red does not show at all. Where am I going wrong?
I'd need to see those expressions.
Conditional formats evaluate from the top of the list down, applying each change in turn. Thus, if both the "yellow" and "red" conditional format expressions evaluate as true, you get a "red" result as it is the last format to be applied to the layout object.
Retrieving data ...