Trying to show a specific field if within a date range

  • adventureclub
    Asked on March 15, 2021 at 3:29 PM

    Hi,

    I'm trying to create a form that will provide the user with appropriate information based on the date they are viewing/submitting the form, basically show a hidden field if today's date is in between a certain date range. I can't seem to get it to work regardless of how I build the conditions. I've tried both numeric and date formats to no avail. Ideally, it would show one description if "School-Age Care" is clicked between mid-July and May 1st and the other if viewed between April and July 1st or both in the times they overlap (April). Please let me know if this is even possible and how to go about it.

    Thanks! Chrissy

  • jherwin
    Replied on March 15, 2021 at 11:17 PM

    I don't think we have a "between" conditional logic for date and months. To achieve your needs, you need to create a "SHOW" conditional logic for each day and show that field.

    If only between months then there is a workaround for that, you just need to get the month number and use that in conditional logic.

    Here's my demo form: https://form.jotform.com/210739048956061

  • adventureclub
    Replied on March 16, 2021 at 9:21 AM

    I don't understand your response and the form you created has no conditional logic built. Can you please provide me with an example that I can borrow from to achieve what I am asking. I was thinking I could use a "before" and "after" date combo to get to the between, but couldn't get it to work. Please advise.

  • Jovanne JotForm Support
    Replied on March 16, 2021 at 10:58 AM

    Hi,

    Please allow me some time to check on this, and I will get back to you as soon as I have more information.

    Thank you.

  • Jovanne JotForm Support
    Replied on March 16, 2021 at 12:02 PM

    Hi, thank you for your patience.

    You can use the Date Picker field and apply the show/hide condition to show some text if the date is within the range.

    1615910043 6050d49b0ecdb  Screenshot 10

    Here's a sample condition:

    1615910379 6050d5eb4f263  Screenshot 21
    You can check my demo form here: https://form.jotform.com/210744731113950.

    Please check and let us know if this work worked for you.

  • adventureclub
    Replied on March 16, 2021 at 2:56 PM

    It works beautifully! Thanks for your help.