Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
6 years ago

Form Rule not firing off based on date field and formula field calculating age

I have a date field [Date of Birth] | a formula field that calculates the age [Age] & a dropdown field titled "Eligibility" (Eligible/Ineligible).

 The business rule is to change the Eligibility field to Ineligible if the Age is < 18. However, the form rule is not firing off the Eligibility field at all.

8 Replies

    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain

      If(Today()>ToDate(ToText(Month([Date of Birth]))&"-"&ToText(Day([Date of Birth]))&"-"&ToText(Year(Today()))),
      Year(Today())-Year([Date of Birth]),(Year(Today())-(Year([Date of Birth])))-1
      )
    • ChrisChris's avatar
      ChrisChris
      Qrew Assistant Captain
      This is not a formula date, it is a formula number. Change your data type for this field to formula number. Other than that, the formula is fine.
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      Doing this will fire off the form rule for the "Eligibility field"???

      The formula that calculates the age is working just fine.