I have a base with information about students in a music program, including their birthdates (MM/DD/YYYY). I have a formula that calculates their age as of today:
DATETIME_DIFF(TODAY(), {Birthdate}, 'years')
and a formula that calculates the number of days to their next birthday:
IF({Days from today} < 0, {Days from today} + 365, {Days from today})
I want to create a field that will tell me how old they will be on their next birthday. Is it as simple as adding 1 to the formula that calculates their age as of today?
Thanks-
Jen