Re: addDays() using field is not working

Hilary Stoupa — Thu, 26 Apr 2018 14:55:19 GMT

I think it could be that when the days valid is returned to your form, the value has a decimal point in it. I found in a test form that if I used a field with a decimal for my "DaysValid" equivalent, I had and ERR? too! You could try using the round function or substring-before to remove the decimal. In your rule, you could have a condition - if the DaysValid contains a decimal, use a formula that handles for it, and then have a second rule for the case where it doesn't. Does that make sense?

addDays() using field is not working

NickiPT — Thu, 26 Apr 2018 12:50:46 GMT

I have a form that has a data connection to another list where a list of certifications are kept. There is a column that has the number of days the certification is valid. In my main form when the user selects the certification, it looks up the number of days it is valid and populates a field called DaysValid.

There is a field called ReceivedDate and another field called ExpirationDate.

When the user selects the date they received the certification, there is an action that should set the ExpirationDate field:

addDays(ReceivedDate, DaysValid)

But the ExpirationDate field then shows ERR?

I have found this issue on several other forum posts but on one it was not solved and on the other it had to do with a repeating table which is not the issue here. Any help would be greatly appreciated!

InfoPath 2010

Re: addDays() using field is not working

addDays() using field is not working