InfoPath Dev

 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

  =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.