Check age category (child, adult, or senior) from birth date

Check Age Category (Child, Adult, or Senior) from Birth Date

ifs(
    dateBetween(today(), prop("Birth Date"), "years") < 18,
    "Kid",
    
    dateBetween(today(), prop("Birth Date"), "years") >= 18 && dateBetween(today(), prop("Birth Date"), "years") < 65,
    "Adult",
    
    "Senior"
)

Note: In this formula, an adult is considered anyone over 18 years old, and a senior is over 65. If these age thresholds differ in your location, simply adjust the numbers accordingly.