Limiting date range choice in a form

Brian Ladwig

A week or two ago I had an issue with automation not triggering properly in a form I created.

Here is a little background. We are upgrading Windows versions on certain workstations. I had a specific range of dates for users to choose from to get upgraded. I originally created a column [Requested Upgrade Date] that was a radio button input on the form. Once this date populated in the text column, a formula moved the date from the text column to a column named [Upgrade Date] which was a date format column.

I then created a workflow that would e-mail interested parties a list of upgrades that were supposed to happen that day. An hour later it would also e-mail a list of upgrades that were past due. Well, the automation did not work as expected. I suspected it was because the [Upgrade Date] column, even though I was set to date format, was not actually in date format.

I did some testing and confirmed this was the case. When I put the date format column on the form and submitted some test entries, the automation worked fine.

This created another problem. In order for the automation to work, I had to allow them to choose the date from the date picker in the form thus abandoning the radio button option. The problem is, I could not find a way to limit the date range that the users were allowed to choose in the form and of course the very first entry after it went live, the user chose a date that was not available.

So, the short version of my question is, is there a way to restrict the range of dates a user can choose when visiting the form I create and submitting it. Please keep in mind, using a radio button or pull down list won't work because I cannot trigger date based automation on anything other than a date formatted column.

I want to make sure I am not missing something before I submit a feature request for date range input limits.

Paul Newcome

one option would be to go back to your radio buttons for options and use a formula in a date type column to convert their selection into an actual date.

Brian Ladwig

I tried exactly that and it did not work. The automation does not seem to trigger unless the information is initially entered into a date format column.

Paul Newcome

Are you able to provide a screenshot of the trigger and condition(s) of your workflow?

Brian Ladwig

I know this is a late reply but after speaking with our rep, this is in fact normal behavior. I did eventually submit a feature suggestion allow us to limit date ranges on a date input on a form. I do not know what the status of that request is.