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
Try this are a formula text field 

var date DOB = [DOB]; // put your date of birth field here

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), "  Missing D.O.B.",
$AGE <= 11, " 0-11",
$AGE <= 15, "12-15,

etc

$AGE >=55, "55+")