4 Replies Latest reply on Mar 20, 2016 6:18 PM by RichardStuart_2

    Conditional Formatting bug?

    RichardStuart_2

      I read elsewhere that there's a bug with conditional formatting involving placeholder text, but I'm experiencing a similar issue where I have a FromDate and ToDate (both are Date fields) where I want the field to turn yellow if the To date is before the From date _if_ the To date is not empty. (The yellow fill is to alert a user that they mis-entered a date.)

       

      If I use the calculation, "FromDate > ToDate"--the conditional formatting calc works. However, when I change the calculation to

       

      "FromDate > not  IsEmpty ( To Date)", the calculation fails.

       

      Am I missing something, or is this part of the aforementioned bug? I've attached a FileMaker Pro v14 test file, created with a Mac.

       

      Ciao,

      Rich