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

3 replies

null
    • UweG
    • 4 yrs 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

    • UweG
    • 4 yrs ago
    • Reported - view

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

    Sorry

    • UweG
    • 4 yrs ago
    • Reported - view

    don“t use the #. It”s “

Login to reply

Content aside

Categories

View all topics
  • 4 yrs agoLast active
  • 3Replies
  • 347Views