JotForm User Guide / Advanced Features /

How to Use the Date Limits Option

How to Use the Date Limits Option

Would you like to set limits on your Date Picker Field? Example, you only want to allow your users to enter dates that fall on a weekend. That is now possible with the new advanced options added to the default Date Picker Field.

First, add the DATE PICKER field to your form then click the GEAR icon.

In the properties section, go to the LIMITS tab.

And here's the complete list of options that you can use on disabling dates:

1. Past & Future

Check the PAST option if you want to allow users to select past dates, same goes with the FUTURE option, check it if you want to allow future dates to be selected.

2. Days of the week

 

Unchecking a day will disable all of the same days in the calendar. You can uncheck which day of the week you don’t want your users to select in the date field. So, to only allow weekdays, uncheck Saturday and Sunday.

3. Start & End Date

Disable dates within the range you set up. This will only allow selection between the dates you selected.

4. Disable Custom Dates

Here you can disable specific dates. The correct format is YYYY-MM-DD but you may also use MM-DD or just DD.

Examples:

2017-07-30 - Disable July 30, 2017

07-01 - Disable July 1 each year

15 - Disable the 15th of each month 

5. Disable Date Ranges

This is similar to the "Start & End Date", but this allows you to set multiple date ranges to disable. This is also a good way to filter out invalid dates. Example, I would like to force users not to enter invalid years like "192", or years that are way in the past "1900" or "1720". What I did is set the date range like this: 0000-01-01>2000-01-01 so users can only select dates from 2000-01-01 onward.

You can also use Dynamic Date Selections. You can achieve this by utilizing the Start & End Date limit and use today+x (where x is the number of days to be added to today).

Say, you're working on a booking form and would like to limit the booking dates to be at least 1 week after submission, and at the same time, you want to limit the booking window for just 1 week. For this to happen, you need to set the Start Date to today+7 (1 week after) and the End Date to today+13 (a window of just 1 week).

Here's the result, given that today is July 16:

Comments and suggestions are welcome below. If you have a question, post it in our Support Forum so we can assist you.

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

63 Comments...

See all comments
  • fjserasi

    hi, just need you to hep me?

    I have a ceremony on 3/10/2020. I have set the age from 3 years to 7 years. My customer must fill in the birth date before come to the event. How to make an age calculation from the date of birth date until the day of the ceremony?

  • zamrai

    hi im working for a rota in our department. i need to control the request day off each day ony 10 staff can request more than 10 will be close. please advice me on how i can do it. thank u

  • Angst

    I would like to make it so that my customer can not choose tomorrow as a date entry after 2PM today. Is that possible?

  • talhah.elsb

    Hi. Please advice me.

    Situation, i want to use date picker to select date range. Range from 1st date to 2nd date with different timestamp. So, i used 2 Date Picker.

    Example
    Start:
    11 /6/2020
    End:
    14/6/2020

    Problem occur when user also can select the date in enddate before date in startdate. Example,
    Start:
    14/6/2020
    End:
    11/6/2020

    Any warning to force user to select the correct date in enddate. The date in enddate must after startdate .

    Thanks.

  • axelphillips

    In case I set a start date AND "time" and a finish date AND time. In case the chosen date is the same day but the times are incorrectly...

    Example:
    Start 6/4/2020 at 11 PM
    Finish 6/4/2020 at 8 AM

    Any warning to force the user to correct the time? due to the fact, the time on the start date must be early from the finish date?

    I think the condition only applies to the date, there is no way to apply any condition whatever the time is? please confirm...

  • bcsdtechnology

    I have used the date picker as a creation date for a form. I do not want the user to back date the form. As the form moves through the approval conditions this could take a couple of days. The people approving are being stopped due to date being older that the current date of approval. What is the work around?

  • chad001

    Hi, I am creating a Sinking Fund form, where a member can apply a loan and reserve the money on a specific date. Each member has a different contribution to the Sinking Fund. Please see below example;

    Member A - $300 Contribution bi-monthly with a total of $7,200 in 12 months (300x24)
    Member B - $400 Contribution bi-monthly with a total of $9,600 in 12 months (400x24)
    Member C - $500 Contribution bi-monthly with a total of $12,000 in 12 months (500*24)

    What I want to expect is All members will allow to borrow an amount of $10,000 until May 31 only of the year. In June 1 of the year, the member can borrow the amount based on their yearly contribution.

    For Example:

    Member A wants to borrow an amount on July 3 with an amount of $10,000, but his yearly contribution is only $7,200.

    I want to create a conditional form that the user will only borrow the $10,000 from January 1 to May 31 only. And on June 1 to November 30, the user can borrow an amount based on their yearly contribution.

    Is it possible?

  • popschool

    Hi, I made a form to cancel a monthly subscription. I want it to automatically calculate the end date.
    We have terms that says: It's only possible to end the subscription on the 1st of each new month with a minimum period of 30 days (1 month).
    Is there a way to calculate that?

  • Dingo69

    Hi Is there a way to delete uploads to create space again once I have downloaded the uploads?

  • michaelajones

    I have limits set up for specific days of week and today + x. The form grays out the dates I want to disable as specified. However, people seem to be able to select those disabled dates anyway. Does the feature only work to disable the dates in the date picker? What can I do to prevent acceptance of the form if an allowed date is not selected, if anything? Do I need to add a form condition? Thanks.

  • QualityQuickPrint

    LOVE the new options for date selection and prevention!!

    Request: could a checkbox for US holidays be added so holidays that are not a consistent day each year be automatically limited (e.g., Thanksgiving, Easter are holidays that are not tied to a consistent day like Dec 24, July 4)

  • BluePearlsEnrichmentFoundationI

    Hi,

    I do not want to receive any submissions after March 2, 2020. If I use the Disable Custom Dates field and enter 2020-03-02, will this stop all submissions for the form?

    or

    If I want to have the form available to students between the dates of December 31, 2019 and March 2, 2020, can I use the Start Date and End Date field to accomplish this setup?

    Thank you.

  • valeriaanissina

    I want to limit submission to only 18 year old applicants. Since the days differ yearly I cannot use today-6570. Is there a more bulletproof way? So 18 years ago would always be the same date as today.

    So if today is 11 august. then 18 years ago it would be 11 august as well, not 12 or 10 august

  • vttschool

    Can I have people choose multiple dates in one calendar?

  • renewme

    My business is open different hours each day of the week. How do I create a "Booking Form" that reflects this? You currently allow all hours of the day, which is not realistic for business bookings. My business:'
    Sun/Monday: Same location (Our spa) but different hours
    Tues-Sat: Mobile location yet same hours

    Baseically, how do you adjust the available times depending on each day?

    Thanks
    Laila
    213=315-9551
    laila@renewmespa.com

  • mway123

    I am wondering if I can have a data field range where I can have a survey open between certain dates every week

  • GerardBarlow

    Is it possible to include hours and minutes in the date range?

    I have a form and I want to make 3pm the cut off time for selecting tomorrows date.

    So users would be able to select tomorrows date at 14:59 but tomorrows date would be unavailable to someone trying to select at 15:01

  • quinnpone

    i am using a form for hours worked the last week. So an employee may be in the app any day. can i set up an algorithm so that I can set the date to the previous friday regardless of when the employee is using the app?

  • euney.kim

    Is there a way to eliminate Saturdays and Sundays from this calendar completely? I want to set a time set that the customer cannot book until 3 days out, however Saturdays and Sundays are not included in that 3 days. i.e. If a form is submitted on a Friday, then the earliest they can get it is Tuesday or Wednesday.

  • jshepherd

    I am having trouble with the the Dynamic Date. When I put in 'today + x' into either fields, it sets the date to January "x", 2001 for that field.

    ie. in my form, I put "today + 2" in the Start Date field, and the date set itself to 2001-02-01.

    https://form.jotform.com/82328511378156

  • auntielilascookies

    I'm having trouble with the Dynamic Date selection. I tried today + 2, Today + 2, today+2... I'm still able to select a date earlier than two days from now. Please help.
    https://form.jotform.com/90872873958174
    Thank you!

  • sebasgarro

    Is the option Today+x still working? I am testing it and I am still able to pick before two days.

  • Isanagui

    A mi me gustaria poder tener la opción de yo en el calendario, marcar días aleatorios en los que se realizará la actividad, y que las persones marque en que dia realizaran la actividad.

  • MederoA

    Is there a way to disable a certain time on a reoccurring day of the week?
    Ex: Fridays after 5pm

  • julesw01

    Is there a way for a customer to select multiple dates e.g. for recurring events?

  • brookdando

    Hi there,

    Is there a way that start date can be referenced to another date picker e.g

    Launch Date = 18 November 2018
    in the start date it is limited to today+14 so user cannot select a closer date

    End Date = (insert end date)
    in the start date limits it would be {launchDate}+21
    effectively removing the ability to select an end date that is less than 3 weeks from the launch date entered

    Hope this makes sense

    Regards
    Brook

  • shtjotform

    Hi
    I am having trouble getting the date requested correct. I've used Today+2 in the start date field.
    For an order, we only want the date requested to be two business days after today. I've disabled the Saturday and Sunday date lines and disabled certain holiday dates.
    Not sure what I am doing incorrect for the Today+2. Can you please review?
    Thanks

  • Heather

    I switched from google forms just so I could have better control over the calendar. The capabilities, and ability to restrict dates, on this date picker are amazing.

  • BRSOatJPRCPA

    How do I allow for a date range? eg 8/23/2018-8/27/2018

  • tutuprat

    How can I disable today's date?

  • CKSFASHION

    Hi,

    We want to restrict the number of persons that can select a date.
    How can we do this?

    Thx!

  • preppypetmelbourne

    1.) how can I set certain hours limits
    2.) how can change the date time on the email to show dd mm yy im getting mm dd yy.

  • TimTaler36

    Hi there,

    how can I ensure that the end date has to be after the start date? Currently the end date can be earlier than the start date.

    Thx & BR,
    TimTaler

  • Vconnect

    I dont want an enquiry that is needed any date after 30 days from today.
    How do I disable after-30-days selection?

  • WTAAWitz

    Hello,

    how can I limit the date picker, so that only the last day of each month can be chosen?

  • davidperriman

    I have set the date so that they can only select a Tuesday but I only want them to select the Tuesday of the next/current week. (I.e. so that they can only select this Tuesday and not one in the future. How do I achieve that?.

    Dave

  • sarahdurkin12

    Is there away I can set a limit on the amount of times a day is picked?

  • FABIANAROXOS

    How to limit hours?
    We do not work between 20:00 ~ 06:00

  • pawel.idzi

    Hi, there is a bug in option Start Week On - Monday doesn't work...

  • AichaLang

    Hello
    Is there a option that every date can be chosen only once. So after a speaker is fixed for a specific day, the date cannot be entered anymore?

    Many thanks and best regards,
    Aicha

  • BetsyCohen

    How can i restrict time to working hours only?

  • teamfear

    I'm having the same problem with the Start & end date

  • thcm

    I'm trying to create a sign-up form and post the link but not have it active until a specific date. Post it today (8/22) but not have the form "live" until September 1, for example.

  • eelcoschuller

    Hi,
    I'm wondering what options there are in the 'Dynamic Date Selections' this article talks about.
    Does it only support combinations with 'today'?

    I'm looking to exclude wednesdays in even weeks, and thursdays in uneven weeks.
    Hope that's possible!

    Thanks

  • JessieJay

    Bonjour,
    Peut-on limiter les créneaux horaires svp? Si cela est possible, comment faire?
    Merci.

  • knuivert

    Hi,

    In the settings you can disable the past dates, but is it possible to disable the present day for the second user who's filling in the form today? So, user 1 that fills in the form today can choose today and send in the form. User 2 that fills in the form today can select a day starting by tomorrow. Thanks already for your answer.

  • wsrhodes

    Start & end date doesn't work. I put in 1/1/1985 - 12/31/2006. When I use the form ANY date I enter is accepted. Why??
    form: https://form.jotform.us/71165312076147

  • aorner

    My data selector limits to only Saturdays, aka "Week Ending Date". How can I limit to the previous 4 'week ending dates' and future week ending dates? For example, if today is 5/15/17, I would expect possible data selections to be 4/22/17, 4/29/17, 5/6/17, 5/13/17, and all future week ending dates (5/20/17, 5/27/17, etc). In this example, user would not be able to select 4/15/17, 4/8/17, and prior.

  • sandiseni

    Hello, is it possible to add a function where I can set a limit of bookings per date. For example maybe I only wanna take ten bookings per date nothing more

  • PDQ_Printing

    I need the date picker only to allow dates that are 3 business days in the future. As it is now, if someone submits an order on a Friday, the DatePicker allows them to choose Monday, when it should be Wednesday. I need the DatePicker to skip over the weekend when counting 3 days. Is this possible?