Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

How do I include or exclude a person within a date range with just a person's birth date and today date?

 I need to set this formula up over six potential date ranges that a person's record in the database could fall into. The only null condition I can think of is if a data entry person forgets to put th...
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

I am getting the formula to work somewhat. when I test it, I am getting incorrect results. I have tested the formula so far by:

  • Removing a date in the 'Date of Birth' to see if it returns the 'null' condition, "Missing D.O.B." which it does not.
  • There also seems to be something wrong with the age range '0-11' as it returns records that are over 11 years of age.


Any suggestions on how to fix? If making the field return just a '1' if the record is within the age range or a null or 0 if the record is in the age range is easier, that would be great as I need to just count those records in each age range anyhow.