0
Help with equation
“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
Like Follow
3replies
-
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 “