Field calculation giving erratic results
I have two fields for data input, AGE and BIRTHDATE. Sometimes the user knows a person's actual birthDATE, and can enter it. And sometimes they only know how old someone is, say 54, and they can enter that in the AGE field.
Related to those two input fields, i have created 4 calculation fields (see screenshot showing the 4 calculations).
I just noticed that there is an occasional problem with "Under30_BD_calc" — the answer should be giving me the actual BIRTHDATE for anyone who is under 30 years old, if there is a date in the BIRTHDATE field.
See the screenshot "ss-2-good" which shows how this works well.
But as seen in screenshot "ss-1-not working", for some reason this one is not working. Since the person's age is under 30 (6), AND there IS a date in the BIRTHDATE field, then i should be seeing that date in the field "Under30_DB_calc".
Any ideas why it doesn't work consistently? And how to fix it?