I changed birthday to {Birthdate} and used your example, but it failed.
Birthdate is my Field Name
See below:
IF({Birthdate}, DATETIME_DIFF(TODAY(),{Birthdate}, ‘years’) & RIGHT(ROUND(MOD(DATETIME_DIFF(TODAY(),{Birthdate},‘days’), 365)/365, 1) &’’, 2...
Thanks for your response to the “Age” question.
How about instead of Years and Months, you want Years and a Decimal Equivalent for months.
For example exactly 12 years 6 months would simply be 12.5 years old. How to do that .5 calculation within the...