Re: Add Months to a date field

wilkies0106aw — Tue, 12 Nov 2013 17:22:45 GMT

=DATE(YEAR([Date Registered ANV]),MONTH([Date Registered ANV])+[Months],DAY([Date Registered ANV]))

yes it is a common formula, but works in SharePoint calculated columns, not directly in an InfoPath form. If you have SharePoint you can use the above.

You might be able to use something like - http://www.hornerit.com/2010/10/infopath-date-calculations-and-date.html to get the date that you want directly with InfoPath.

Add Months to a date field

d24n4e — Tue, 12 Nov 2013 12:07:50 GMT

Hi,

I would like to add a date reminder field to my InfoPath that is the date in field Date Registered ANV plus 36 months (field Months).

http://office.microsoft.com/en-gb/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx#BM2

I have used the formula listed here, but get an error message to say the operand is not an expression.

=DATE(YEAR([Date Registered ANV]),MONTH([Date Registered ANV])+[Months],DAY([Date Registered ANV]))

Is anyone able to point out where I am going wrong please?

The other formula I tried is addDays(Date Registered ANV, 1095) for the number of days in 3 years, however it then takes 1 day off the registered date and I need it to be exactly 3 years to the date.

Thank you

Newbie Questions

Re: Add Months to a date field

Add Months to a date field