General

Re: Adding a date field and a number field to calculate a new date?

ChristinaGateley — Thu, 30 Mar 2017 15:09:12 GMT

I hadn't thought about it, but you could be right!

I tried the alternative and that worked great also.

Thank you very much for your help and time :)

Re: Adding a date field and a number field to calculate a new date?

Hilary Stoupa — Wed, 29 Mar 2017 14:34:26 GMT

Do you suppose leap year is coming into play here at all? If you really just want to add years, let me know - you could do that with a substring formula, because incrementing the year is simple. XML dates are stored in yyyy-MM-dd format, so you can use substring-before to get just the year and increment it.... something like: concat(substring-before(fieldWithDate, "-") + fieldWithNumberOfYears, "-", substring-after(fieldWithDate, "-"))

Re: Adding a date field and a number field to calculate a new date?

ChristinaGateley — Wed, 29 Mar 2017 10:59:51 GMT

P.S. this doesn't happen for every entry so could this be dependent on the time that the document was created/published?

Thank you.

Re: Adding a date field and a number field to calculate a new date?

ChristinaGateley — Wed, 29 Mar 2017 09:26:43 GMT

Hi Hilary, The formula worked great; thank you. My only issue now is that whilst the month and year is calculated correctly, the day is not. It appears to subtract day. For instance, I have a document with a 5 year review period from today, so I'd expect the review by date to be 29/03/22, but it returns as 28/03/22. Do you perhaps know why it does this and what I can do to solve it? Best wishes, Christina.

Re: Adding a date field and a number field to calculate a new date?

Hilary Stoupa — Tue, 28 Mar 2017 14:43:12 GMT

You'll need to use the addDays() function in InfoPath. So in your formula editor, click the button for inserting a function, and find the addDays() function. The first parameter is your date field and the second is the number you want to add. So maybe xdDate:AddDays(../my:field8, (../my:field22 * 365))

Adding a date field and a number field to calculate a new date?

ChristinaGateley — Tue, 28 Mar 2017 09:11:20 GMT

Hi, I hope someone can help.

In my form I have a date field and a number field (this number field represents a year, so if the value is 1 then it equals 1 year).

I want to add these two fields to give me a new date. I've tried but I just get a return value of NaN, as you'd expect.

Please can someone help me with the calculation so I get a date value?

If it helps, the calculation I have tried so far is: ../my:field8 + (../my:field22 * 365)

Thank you.