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