AnsweredAssumed Answered

Conditional formatting inconsistency in FMP10

Question asked by Davis on Oct 27, 2009
Latest reply on Oct 27, 2009 by mrvodka


Conditional formatting inconsistency in FMP10


My formatting on a date field says this order


Value is less than 2 days ahead, fill color = yellow (the date is coming up)


Formula is GetAsDate(mydatefield)< Get (CurrentDate) & IsEmpty (my checkbox field), fill color = Red (You didn't check the box, and the date has passed, so color is red)


Formula is GetAsDate(mydatefield)=Get (CurrentDate), fill color pink (you didn't check the box, and date is today)


Value is empty, fill color white (there is not date, so no formatting)


Formula is (my checkbox field) = "1", fill color white (the box is checked, so make the field white regarless)


So, this seems to work most of the time, with a few exceptions. If there is a date for 2010, the field is red indicating that its late...possibly because it thinks that January comes before October...?


Also, some dates that are Oct 1 are showing yellow, even though today's date is Oct 27. Very random colors. If anyone has a better way, please let me know.


I had to put the last step in about checkbox="1" because it wasn't being recognized in previous steps so it has to be its own step...and that's possibly another bug..?


Has anyone else had this happen?