How to validate if the date entered by the user falls within a date range?

"How to make one of the delivery date not available"- Support forum

If you deliver, run a course or take bookings only on certain dates, a date question that accepts any date means calling people back to change it. Date questions in Google Forms accept any date, with no option to limit the range. With Formfacade, a date question has its own validation rules, so you allow only the dates between a first and a last date and people can only pick a day you can serve them. The responses are still collected in your Google Form, so you can sort them by date in Google Sheets.

Import your Google Form and follow the steps below. The example lets customers pick a delivery date between 25 September and 1 October.

Date validation: Specified date range

  • On the page that opens, paste your Google Form's link or click Browse to pick it, then click Next. Your form opens on the "Preview" tab.
The Make a copy of Google Form & customize it screen, with the link box and the Next button marked and a Google Form's link pasted in
  • Click on the "Edit" tab.
The tabs Edit, Preview, Share and Responses, with Edit marked
  • Click on the + icon (Add field) in the toolbar on the right.
  • Enter "Choose your preferred date" as the question and select Date in the question type list.
The toolbar on the right of the Edit tab, with the + icon marked
  • Click on the ⚙️ icon at the bottom right of the question.
  • Select the "Answer" tab and click Configure under Validation.
  • Select "Allow between two dates" and enter the first date and the last date.
  • Click Save.
The Validation section with Allow between two dates selected and two dates entered, with the rule and the Save button marked
The date box on your form will now allow only the dates between these two dates.

Summary

If your users can only choose dates in a certain range, Google Forms cannot validate it. With Formfacade, you can add the Allow between two dates validation to the date question. Import your Google Form and complete the steps above.

Accept only dates within a range on your Google Form.

Import your Google Form, choose Allow between two dates under a date question's Validation and enter the first and last date. Only those dates are accepted.

Last updated: