General

Re: Validating End Date from Start Date

donstephen — Tue, 08 Sep 2015 23:26:00 GMT

Glad I could help. Cheers!

Re: Validating End Date from Start Date

benny.mcpherson — Tue, 08 Sep 2015 17:34:22 GMT

Thanks Don,

Worked perfectly.

Re: Validating End Date from Start Date

donstephen — Mon, 07 Sep 2015 06:46:06 GMT

Hi Benny,

Could you try adding a validation rule at the EndDate field with the following formula for the condition:

click condition and select "The expression" from the first dropdown control, be sure to replace the xpath for StartDate with the correct one.

. > xdDate:AddDays(../my:StartDate, "365") and . != ""

The condition woud look similar to this after adding:

EndDate > addDays(StartDate, "365") and
EndDate is not blank

This way, if the EndDate is greater that StartDate + 365 days, a validation error will appear.

I hope this was clear enough. Please let us know if this doesn't work for you.

Regards,

Validating End Date from Start Date

benny.mcpherson — Tue, 01 Sep 2015 01:37:17 GMT

I have a form where I would like to prevent user from selecting a end date that is more then one year from the start date (InfoPath 2013)? Any suggestion would help. Thanks