Conditional formatting inconsistency in FMP10
My formatting on a date field says this...in 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?