Incorrect result in calculating dates

  • daveperryman_reesfoundation
    Asked on November 8, 2021 at 7: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! :-)


    Jotform Thread 3492123 Screenshot
  • Harvey JotForm Support
    Replied on November 8, 2021 at 9: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 Screenshot 10

    1636381039 6189316f115a0  Screenshot 21

    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.

  • daveperryman_reesfoundation
    Replied on November 10, 2021 at 7:33 AM

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

    thanks

    Dave