Incorrect result in calculating dates

  • Profile Image
    daveperryman_reesfoundation
    Asked on November 08, 2021 at 07:50 AM

    Hi Folks

    I've tried the calculations for dates to Add 364.25 days to a specific date and the results keep coming up with 1899.

    I basically want to have a Membership Start date calculation 12months to the Day for membership end date.

    Also the Membership 14day cool off period also should add 14 days to the start dates but seems to add the wrong year?

    See attached images, is there a format for the dates or a criteria I need to make sure the Dates are related to this Century! :-)


  • Profile Image
    Harvey_N
    Answered on November 08, 2021 at 09:23 AM

    Hi there,

    I've checked your form and tried to replicate the calculations that you've used in generating a date after 12 months (365 days) and 14 days was able to generate the correct date. The result posted on the tables has a correct date as well.

    abb3d046df1b4dd8a870e40ee4f012bf.gif

    1636381039_6189316f115a0_

    I've cleared your form cache. Please try to logout and clear your browser cache and try to login in again and test the form.

    Test form: https://form.jotform.com/213113598176054

    You can clone the form that I created to see the calculations I've used: How-to-Clone-Form

    Let us know if you still getting the same issue.

  • Profile Image
    daveperryman_reesfoundation
    Answered on November 10, 2021 at 07:33 AM

    Thanks, have logged out and in and cleared cache etc and all seems to work now.

    thanks

    Dave