SharePoint Integration

Re: Attempting to validate a date field in a SharePoint List Form

Hilary Stoupa — Wed, 10 Apr 2013 23:36:11 GMT

To do date math in InfoPath, use the addDays() function. More here.

Re: Attempting to validate a date field in a SharePoint List Form

Campanellisj — Wed, 10 Apr 2013 16:13:27 GMT

I have not tried the adddays()

I was attempting to create a validation rule, Datefield is greater than or equal to datefield+365

Re: Attempting to validate a date field in a SharePoint List Form

ErnestoM — Wed, 10 Apr 2013 15:26:18 GMT

How are you calculating the comparison date? Are you using addDays()?

Attempting to validate a date field in a SharePoint List Form

Campanellisj — Wed, 10 Apr 2013 15:12:39 GMT

I have a need to add validation to date field in a list form that will check that the date entered in the date field (which is a date picker), validates that it is not older than one year from what is entered. Meaning today is 4/10/2013 then the date can not be greater than 4/10/2014 , however everytime I add a rule no validation works. I have tried the now(), the today(), the less than the greater than etc.... and nothing seems to work. I relize that infopath holds the date in a different format but that doesn't help with a solution. I can not add customized code to this form and again it is tied to a SP list, so can anyone provide a work around or fix to be able to validate date fields?