What is JotForm?
JotForm is a freeonline form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

Before and After Date Condition aren't Working

Asked by
tammy1973
on January 25, 2016 at 07:10 AM

page 20 on my form

user has to fill in date of their letter in field 1. This calculates date field 3 by taking away 28 days from the date entered in field 1, so if date of the letter is 29.12.15, then field 3 automatically shows 1.12.15.

field 2 is asking the user to state another date (From which date onwards has the minimum amount been in your account (as stated on the letter)since" and if this date is after field 3 (e.g. 5.12.15) it should go to a specific page with a specific message (page 34).

However, the condition seems to be ignored and even if the date entered in field 2 is after the date showing in field 3, after pressing next, it goes to the next page instead of skipping to page 34?

By the way, I found multiple conditions in your form with the same action statement "skip to page 34". I suggest to combine them by creating multiple "IF" rule just like on the first condition shown below. This will help avoid condition conflict and lessen the conditions list.

If you need further assistance or if there's anything I've missed, please let us know so we can assist you.

Answered by
tammy1973
on January 26, 2016 at 04:18 AM

Hi there, many thanks. I think the reason why it seems to be working fine in your case is that you selected "state the balance on a particular day" and this takes you to page 34.

However, if you select the next option "state the minimum balance...", it goes to the next page rather than page 34. I've now included a page break so I would be grateful if you could try it out again (it's now on page 21) and let me know what I'm doing wrong.

In the meantime I'll clone the form and work on the cloned version and follow your suggestion to have all conditions with the action (skip to page 34 (or 35 as it is now) will be combined.

JotForm Support

Answered by
EltonCris
on January 26, 2016 at 10:45 AM

You're right. I was able to reproduce this problem even on a test form. The before and after condition doesn't seem to work when comparing between two date fields. I have now raised this to our developers for a resolution.

For now, you can try this workaround. Use the form calculation widget to get the decimal value of the date field and then compare them on the condition statement using greater than operator instead of "is after".

Here's a visual guide:

1. Add two form calculation field. On each of the calculation field, insert the relevant date field on the calculation wizard. e.g. For the "End Calculation" field, insert the End Date field to get its decimal value. Do the same for the "Start Calculation", insert the Start Date.

2. And then create a condition that compares the two calculation fields by using "Greater Than" operator like the following. So mathematically, if "End Date" is after "Start Date", then End Calculation field will have a higher decimal value compared to Start Calculation field.

Hope this still helps!

Answered by
tammy1973
on January 27, 2016 at 06:00 AM

Many thanks for your response. Your suggested solution works just fine and does the trick. I've hidden the fields so it's not confusing for the end user and so it's perfect.

JotForm Support

Answered by
Charlie
on January 27, 2016 at 09:40 AM

I'm glad the workaround provided by my colleague worked for you. If you needed any assistance again, feel free to open a new thread here in the forum. We will also update you on this thread as soon as the bug has been finally resolved.