InfoPath Dev

I am attempting to limit the available selection of Days in the date picker and can not find any information on how to accomplish it.  I need the picker to only allow users to select a date three business days after the date of submission.

 So for example if they are filling out the form Friday, April 11, 2014, I do not want them to be able to pick any days prior to Wednesday, April 16th.  Is that possible?

 I have seen some posts about limiting the picker to only be able to select business days, but none on how the limit the first three days.

Hi ander2cc,

Welcome to InfoPathDev.

I would suggest adding a Validation Rule where the condition is EndDate < addDays(StartDate, 3), then set a Screen Tip message. This would prevent the user from selecting days prior to the start date and less than three days after the start date by showing a validation error. Please let me know if this helps.

Regards,

That worked fantastically thank you. 

If the forms with this validation get opened and saved at a later time, you may want to add another field to prevent the validation from running.

Ex:  First time use, the user puts 6 days from now, but someone opens the form 4 days from now, the validation on that field will not allow them to save the form without fixing the date.

If you don't have to worry about that type of event occuring, then the validation works perfectly.

If you do or can have someone open the form at a later date and resave, you may want to add another field, a boolean field (true/false) that is defaulted to false and changes to true when the form gets submitted.
The validation for the due date should check that boolean field to see if it is false.  If it is false, the validation would run.
Once the form is submitted, the validation won't run since the boolean field is true.

Hi snturner,

Both EndDate and StartDate are fields from the form displayed on the canvas. What was needed here was a formula to prevent the user from selecting a date 3 days after the start date.

If user selects May 29 (for the StartDate field), the Validation formula added to the EndDate field will show a validation error if the user selects May 30.

Hope this helps.

Thank you, makes sense now.