How do you create a calculated field that takes the date that a project is completed and add 1 year to that date. | Community
Skip to main content
sljonashi
Level 4
Jul 30, 2020 8:19 PM UTC
Solved

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

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    sljonashiAccepted solution
    Level 4
    Jul 30, 2020 8:35 PM UTC

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

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

    View reply

    2 replies

    sljonashiAuthorAccepted solution
    Level 4
    Jul 30, 2020 8:35 PM UTC

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

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

    Translate
    kynabaker16
    kynabaker16
    Employee
    Jul 30, 2020 8:45 PM UTC

    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.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...