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

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • UweG
    • UweG
    • 1 yr ago
    • Reported - view

    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

    Like
    • UweG
    • UweG
    • 1 yr ago
    • Reported - view

    I was wrong. Year creates a number. The formula is: date(year(“Date of Manufacture#)) + 10, Month, Day)

    Sorry

    Like
    • UweG
    • UweG
    • 1 yr ago
    • Reported - view

    don“t use the #. It”s “

    Like
Like Follow
  • 1 yr agoLast active
  • 3Replies
  • 340Views