Calculating dates not working

  • plott
    Asked on September 20, 2017 at 5:57 PM

    I have a form in which I'm trying to calculate some dates (add 14 days to a date).  I think I've copied one of the examples, but I'm getting bizarre results.  Could  you have a look?

    Also, is there a MOD function that can be used in calculations?

     

  • Mike
    Replied on September 20, 2017 at 6:45 PM

    To fix your calculation, click on the + sign to change its type to the Number (the background should be gray).

    Calculating dates not working Image 1 Screenshot 30

    The modulo operation should be possible with a % sign.

    Calculating dates not working Image 2 Screenshot 41

    If you need any further assistance, please let us know.

  • plott
    Replied on September 20, 2017 at 8:43 PM
    Thanks very much.
    The MOD function will be very helpful.
    The date calculation still doesn't seem to work.
    Peter Ott
    ________________________________
    ...
  • Kevin Support Team Lead
    Replied on September 20, 2017 at 10:49 PM

    I would recommend you to remove everything from the widget and start again, first add the date string function, then the date field with the operation. 

    It should be working, this is how I have set it up on my end: 

    Calculating dates not working Image 1 Screenshot 20

    Here's my cloned form of yours: https://form.jotformpro.com/72628235137962 

    I hope this helps. 

  • plott
    Replied on September 21, 2017 at 7:17 AM

    Got it - thank you!