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
S
sljonashi
Level 4
July 30, 2020
Solved

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

  • July 30, 2020
  • 1 reply
  • 514 views

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.
    Best answer by sljonashi

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

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

    1 reply

    S
    sljonashiAuthorAccepted solution
    Level 4
    July 30, 2020

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

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

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe Employee
    July 30, 2020

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...