Calculation for particular date is not working

  • Profile Image
    bmanfield
    Asked on February 15, 2017 at 07:14 PM

    Hi,

    I'm calculating age and a player division classification fields from a DOB field. The Player Division field is conditional on the registration type being 'Player'. The player division classification isn't populating correctly for a DOB 04/01/2002. Days before and after the birthday calculate the Player Division field incorrectly. The player division field is populated based upon a calculation of the person's age in days at the end of the current year. (31/12/2017)

    The example form I have provided is an extracted clone of the form with the explicit fields involved.

    I've had a look at the conditional logic but cant see anything wrong. Could someone please take a look and tell me what I've missed?

    Cheers

    Ben

  • Profile Image
    ashwin_d
    Answered on February 15, 2017 at 11:20 PM

    Hello Ben,

    I did check your form and did not find any issue with that. I changed the data and also tested it for 04/01/2002 as well but I am unable to replicate the issue. The conditions seems to work as expected and the data is populated in "Player Division" field. Please check the screenshot below:

     

    I would suggest you to please test your form again and get back to us if the issue persists.

    Thank you!

  • Profile Image
    bmanfield
    Answered on February 15, 2017 at 11:32 PM

    Hi,

    Yeah I've been working on the problem in the form provided which is why the form has changed. I figured out its possibly because of the requirement to account for an extra day in leap year and also because the of the requirement for a filter that allows >= instead of just >. I've recalculated the age thresholds in days based upon 365.25 days per year (eg: 10x365.25 = 3652.5) and rounded it down by .001 to workaround the >= requirement.

    Is there a feature to allow =< or >= as a selectable filter?

    I don't know if there's a better way to calculate what I'm doing. Any advice is appreciated.

    I'm still working on it. :-)

    Cheers

    Ben

  • Profile Image
    ashwin_d
    Answered on February 16, 2017 at 02:42 AM

    Hello Ben,

    I am not sure if I have understood your requirement correctly. Are you trying to calculate Age in years or in number of days? Is it your requirement to calculate number of days?

    There is a better way to calculate age. Here are the steps you should follow:

    Here are the steps you should follow:

    #1. Add a hidden date field in your form and hide it.

    #2. Add another date field which users will use to select data of birth.

    #3. Add "Form Calculation" widget in form and add the above formula to calculate age. Please check the screenshot below:

     

    I would suggest you to please take a look at the following form and see if this is what you wanted to achieve: https://form.jotform.com/70194559707970 

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Here is the formula to calculate age:

    floor((Current Date - Date of Birth)  / 365)

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!