Expand my Community achievements bar.

SOLVED

How do you create a calculated field that takes the date that a project is completed and add 1 year to that date.

Avatar

Level 6

I'd like to add a calculated expression in my form called "Expiration Date". Calculation is based on the project "Actual Completion Date + 1 year. So if the project was completed on 8/15/2020, The field "Expiration Date" would display 8/15/2021.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 6

I figured it out, I was using camel case in my formula

ADDYEARS(actualCompletionDate, 1) should have been ADDYEARS(Actual Completion Date, 1)

View solution in original post

2 Replies

Avatar

Correct answer by
Level 6

I figured it out, I was using camel case in my formula

ADDYEARS(actualCompletionDate, 1) should have been ADDYEARS(Actual Completion Date, 1)

Avatar

Employee

Thank you for sharing your answer! If you had the question, I guarantee you that someone else did too! So glad you got it figured out.