Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 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...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
OK, I f you want to easily create a report to look like that, yes I see why you would want to have separate fields.  You would want that to be a numeric formula field to calculate to a 1 or a 0.

var date DOB = [Date of Birth];

var number AGE =
Year(Today())-Year($DOB)
-
If(Month(Today())<Month($DOB)
or
(Month(Today())=Month($DOB) and Day(Today())<Day($DOB)),1,0);

If(IsNull($DOB), 0, $AGE <=11, 1,0)


I did test the formula I originally posted and it worked for me.  Contact me via the information in my profile if you would like some one on one assistance.