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

Forgot to give you the formula I used in the 0-11 age range field:


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