Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
7 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 fi...
Forms
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
7 years ago

Can you post your formula field code?
PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
7 years ago

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
)