Heres the setup:

I have a number field (Elapsed Days) that displays the number of days it took to quote an insured. The field starts at 0 if entered today, and increases every day until the "quoted box is checked" at that point filemaker inserts the current date into a separate field (Quoted Date), and the original field now stops counting up each day and stays on the inserted day.

 

I am trying to create a red bar that displays over all the fields if it meets these 2 conditions: 1. Its greater than or equal to 3 days, so 3,4,5... AND if the separate field IS empty, then display the red bar. Once the field has a date in it, or if the number in Elapsed days is 1 or 2 the bar should disappear. With the formula below I've been able to get the red bar to appear, and disappear once (Quoted Date) has a date in it, however it appears the greater than sign is not working because I get red bars not only on numbers 3 and + but also on numbers 1 and 2.

Please help, thanks.

 

(IsEmpty(BWIA2 FMP11 2::Quoted Date)) & (BWIA2 FMP11 2::Elapsed Days ≥ "3")

Conditional format of:

 

IsEmpty ( BWIA2 FMP11 2::Quoted Date) and BWIA2 FMP11 2::Elapsed Days ≥ 3

or

not BWIA2 FMP11 2::Quoted Date and BWIA2 FMP11 2::Elapsed Days ≥ 3

Corrections:

& appends two strings together:
  "ab" & "cd" -> "abcd"

"and" is a boolean operator:
  True and False -> False
  True and True -> True

 

Also numbers do not need to be wrapped in quotes.  The second calc is turning the date into a boolean.  All dates contain a number so boolean would be true.

Edited February 28, 201312 yr by LaRetta