“Date of Retirement” := date(year(“Date of Manufacture” + 10), month(“Date of Manufacture”), day(“Date of Manufacture”))
Can anyone help me with this? When I use this equation it isn“t adding 10 years to the date. Am I using it correctly?
Thanks
year() generates a text.
You have to convert year() back into a number to be able to calculate with it. Best with number(year())+10
I was wrong. Year creates a number. The formula is: date(year(“Date of Manufacture#)) + 10, Month, Day)
Sorry
don“t use the #. It”s “