Show / Hide Table of Contents

    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.

    • Improve this Doc
    Back to top Copyright © 2013-2021 Vitaliy Korney
    Generated by DocFX