Calculating Date with Time

My Vehicle Registration -Parking Permit Form

I am trying for the following:

Once someone clicks on "Hourly" the "Submitted At" should automatically calculate + 4 hours and output the result on the Thank You page with the Date and Time (4 hours from the time of submission)

If someone clicks on the "Overnight" the "Submitted At" should automatically calculate +24 hours and output the result on the Thank You page with the Date and Time (24 hours from the time of submission) but I can't seem to get it to work. I believe my calculations are correct but they don't seem to be working.

I think the 4 hour might be working but, not the 24 hour.

Hi Melissa,

Thanks for reaching out to Jotform Support. I checked your form and your calculations are correct. The reason why your 24 hours is not giving the correct result is because in its formula, you're already adding 1 to it:

And in the condition, you added another 1 again:

That is why instead of adding only 1 day, it's adding 2 days:

Remove the +1 in the condition and it should give you the correct value. As for the Thank You page conditions, I see that it is also configured correctly. Just one thing you need to update is the Limit of your Formatted 24 Hour Expiry field. Make sure to check either one of these and your form should be working as expected:

Reach out again if you need any more help.

Hello,

Sorry it's still not working for the 24 hour. It's giving the same day and the 4 hour time frame.

Hi Melissa,

I cloned your updated form and showed the hidden fields for testing purposes, and it's showing +1 day and +4 hours on my end:

Can you take a screenshot of what you're seeing on your end and send it to us? This guide will show you how to do that.

Keep us updated and let us know if you need any more help.

It should only show 24 hour time frame difference when Overnight is selected. Also on the Thank You page, it's not updating with the correct 24 hour date/time.

Hi Melissa,

I checked your form again and I noticed in your 24 Hour Calculation formula, the +1 was removed:

Add it back, and your 24-hour time frame result should be correct. As for the Thank You page, it shows the wrong condition since the condition below is still true even if the form user selected the Overnight option:

Update it to this condition instead:

And that's it. Here's also my demo form that you can clone and check out.

Let us know if you need any other help.

Now my 4 hour thank you page doesn't show anything since I updated it as you mentioned.

24 hour thank you page seems to be working..off by a couple minutes but that is okay. If we can figure out how to get it on time as I know some could complain about that, that would be great but not the end of the world. However, the 4 hour is not working now with your last update suggestion.

Hi Melissa,

Here's the condition you set:

The correct one is this:

As for the accuracy of the time, I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Let us know if there’s anything else we can help you with.

Hi Melissa,

I did some tests and found a solution for the accurate time. You don't need these Form Calculation fields, so you can delete them if you want to:

As for the conditions, you can delete the existing ones and replace them with these conditions instead:

Here's a sample result:

Here's my updated demo form that you can clone and check out.

Reach out again if there’s anything else we can help you with.

It didn't calculate the correct time, still off by a bit:

However, the 24 hour is right on target.

Hi Melissa,

I cloned your updated form and it gave me the correct time. See my screenshot below:

This could be a temporary issue, so I've cleared the form cache to fix any possible cache issues in the form. Can you try again and see if it now gives the correct time?

Give it a try and let us know how it goes.

That worked! Thank you.