Form Calculation: Calculating number of nights between two date fields

Hi there,

I've tried many different conditions and different widgets and methods trying to calculate the number of nights between two date fields, with no luck. Can you advise what I'm doing wrong? I've tried multiple widgets, with and without time fields and no change.

Hi Lyndal,

Thanks for reaching out to Jotform Support. I have checked your form, and it looks like you're trying to use both calculation widget and conditions to get the total number of nights. Let's first disable the conditions, since they are not needed:

1. While in Form Builder, click on Settings at the top orange bar.
2. Choose Conditions from the left menu.
3. Click Select All to select all conditions.
4. New buttons will appear, and click on Disable.

Now, let's configure the calculation widget:

1. Go back to Form Builder, by clicking the Build option from the top orange bar.
2. Select the calculation widget by clicking on it.
3. Click the Wand icon next to it.

Configure your calculation like this:

You should now get a difference between the two dates:

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

Thank you so much, this worked! I was doing way too many things for a simple action.

Hi Lyndal,

I’ve gone ahead and moved your other question to a separate thread to keep things tidy, and someone from our Support Team will help you out with it here.

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