I need a Checkbox formula based on birthdates. If the birthdate is fewer than 18 years ago, based on today, I want the box checked, designating the client as a minor.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
If Birthday field is fewer than 18 years ago, I need a formula that automatically checks the "Child" box, designating the client as a minor.

If it is blank or more than 18 years ago, it can be left un-checked.
Photo of Joy

Joy

  • 0 Points

Posted 4 years ago

  • 0
  • 1
The formula should be

IF(

IsNull([Birthday],false,

AdjustYear([Birthday],18)>=Today(),false,true)
Photo of Joy

Joy

  • 0 Points
There is a Syntax error "Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket."

But I'm not sure where the trouble is. Ideas?
missing bracket

IF(

IsNull([Birthday)],false,

AdjustYear([Birthday],18)>=Today(),false,true)