Help me write a formula that is dynamic
Me again. This is the perfectionist in me. I'd love suggestions on if it's possible (and how) to write a formula that calculates a person's age based upon DOB field, converts it into a category ("0-...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOnce that tests OK then make a new field for [Age Category]
IF(
IsNull([My Date of Birth field]), "",
[Age] <=12, "0-12",
[Age] <=17, "13-17",
[Age] <=25, "18-25",
etc
[Age] <= 65, "50-65",
, "66+")