How to calculate age in MobiDB database
Based on the following link you need to add calculable expression in the designer:
Add the following expression called diff
:
getyear(getnow())-getyear(birthday)
And add the following expression to the calculable field:
if (birthday>AddYears(getdate(getnow()),-diff),diff-1,diff)
Result:
Example can be found here.