I would guess that the check box "do not evaluate if all referenced fields are empty" check box has not been cleared for AgefromBD_calc.
This should also be an unstored calculcation or it will not update to show a different age as time passes.
And your BD calc can be off by 1 if today's date is < this year's birthday for a given individual.
per your suggestion, I have made them unstored.
however, your other suggestion, to uncheck "do not evaluate if all...are empty" -- i tried this; it did not fix the problem; but it did start to give me question marks in the field, and i don't want to see the question marks... i'd rather see the field be empty; so i re-checked that option.
Perhaps one more illustration might give you a better idea of what the problem is — see attached file for how these fields are displaying.
As you can see, the problem only shows up in the single digit ages (with the exception that one of the 2-year olds, showing a birthdate of 11/29/2011, actually shows perfectly!). Does that give you any further ideas?
Yes, remove the quotation marks from around the numbers in your calculation. Putting them in quotes causes fileMaker to treat your numbers as text. As text, "200" < "5" is a true statement.
Thank you! That solved the issue completely!