Newbie Questions

Re: InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates.

Hilary Stoupa — Thu, 05 Nov 2020 00:44:39 GMT

Were you able to try my suggestion and in the column settings in SharePoint use an and function to combine your current logic with a not blank? So that the formula basically says "If this date field is NOT blank AND this date field >= Today, it is invalid"? I don't know the SharePoint formula syntax offhand but let me know if you need help with that.

Re: InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates.

Toba Shosen — Thu, 05 Nov 2020 00:24:12 GMT

I apologize Hilary, I'm working on 2 issues with this form. I meant to say Date Picker field above instead of Attachment field. Please see if this makes more sense.

I have an existing form with 3 Date Picker fields, and I'm being asked to add another Date Picker field, a Required field, called Preferred Completion Date, that is part of the form that is submitted. Another request is to make all 4 fields to not accept dates from the past. I've created the Preferred Completion Date list column with this formula, =PreferredCompletionDate>=TODAY() The other 3 Attachment fields are not Required and are in the section of the form that is filled in by the staff that receive the form when it's submitted. Is there a way to make these 3 fields also not accept dates from the past, and allow the form to be submitted when they do not contain data? Please let me know if you need more information.

Thank you

Re: InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates.

Hilary Stoupa — Wed, 04 Nov 2020 00:20:15 GMT

If you are using validation on the column in SharePoint, I'd think you could use an "and" formula and include a condition that the date field is not blank. I'm confused about your mention of attachment fields tho - a list form can only have a single, repeating attachment field?

Re: InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates.

Toba Shosen — Tue, 03 Nov 2020 00:48:04 GMT

Hi Hilary,

I have an existing form with 3 Attachment fields, and I'm being asked to add another Attachment field, a Required field, called Preferred Completion Date, that is part of the form that is submitted. Another request is to make all 4 fields to not accept dates from the past. I've created the Preferred Completion Date list column with this formula, =PreferredCompletionDate>=TODAY() The other 3 Attachment fields are not Required and are in the section of the form that is filled in by the staff that receive the form when it's submitted. Is there a way to make these 3 fields also not accept dates from the past and allow the form to be submitted when they do not contain data? Please let me know if you need more information.

Thank you.

Re: InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates.

Hilary Stoupa — Mon, 02 Nov 2020 23:44:08 GMT

Well, I'm not sure I understand this. I'm guessing you are using custom validation and need to modify the validation formulas to allow the date pickers to be blank if the required date picker is set? Feel free to attach your form, or a sample that demonstrates the issue, to a reply under the options tab and I'll take a look.

InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates.

Toba Shosen — Wed, 28 Oct 2020 15:17:40 GMT

InfoPath 2013 form with multiple Date Picker fields containing a formula to not allow entries for past dates. The form has one required Date Picker field and 3 not required Date Picker fields. I want to allow the one required Date Picker field when the form is submitted to not demand a date be entered in any of the other Date Picker fields.