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 LegendIt sounds like you have a relationship where one person has many "Service Provided records".
You can make a new field there for Age at Service Provided date.
var date DOB = [My Date of Service Provided field]; // update with your own field here
Year(Today())-Year($DOB)
-
If(
Month(Today())<Month($DOB)
or
(Month(Today())=Month($DOB) and Day(Today())<Day($DOB)),1,0)
Then you can make a [Age Category at Date of Service] field there too.