fbpx

Reply To: Roundings in calculations

Forums Designer Building applications Roundings in calculations Reply To: Roundings in calculations

    I have a DB (Child) with the following fields: Name / date of birth / Place of birth / Age.

    In a user flow I do the following:

    Start with the DB Child -> step 1 -> calculation ( Current date – date of birth)

    step2 -> Calculation (result step 1 / 1 days) = convert the value in to days

    step 3 -> Calculation (result step 2 / 365,33) = age in years

    step 4 -> edit data (field age / DB Child) with the value from step 3.

    Example:

    Current date 31-08-2020 – DOB 26-09-2011 result = 9

    Current date 31-08-2020 – DOB 09-07-2019 result = 1

    The second one is correct, but the first example is not 9 yet

     

Get a free trial to discover what Triggre has to offer!

By signing up for your personalized walkthrough, you agree to receive e-mails from Triggre.