dburnham

Conditional Formatting not evaluating dates correctly

Discussion created by dburnham on Sep 10, 2017
Latest reply on Sep 11, 2017 by TSGal

If you ask Conditional Formatting to use "less than" a date value with the FMP option list of operators, Less than is behaving like Less than or equal to.  FMP inserts "Self" instead of the field name.

 

But if you change it from Value to Formula and write your own calculation using < instead of ≤ and specify the field name instead of using "Self" then the conditional formatting behaves properly.

 

 

I suspect this is because FMP is surrounding Get(CurrentDate) with quote marks which becomes visible when you change from Value to Formula but when you remove the quote marks, it behaves correctly whether you use Self or the field name

Outcomes