ADDDAYS function not working? | Community
Skip to main content
amybillmayer
amybillmayer
Level 4
December 27, 2023
Solved

ADDDAYS function not working?

  • December 27, 2023
  • 1 reply
  • 824 views

Ok, this is driving me crazy. It seems so simple, but for some reason it isn't working.

I need to add a column to a project report that adds 5 days to the Last Update date to indicate when a project can be closed.

 

Here is my calculation:

 

displayname=Close by
linkedname=direct
textmode=true
valueexpression=ADDDAYS(lastUpdateDate,5)
valueformat=atDate

 

I'm getting a blank field. What the heck am I missing here?

 

Thank you in advance for any help you can provide!

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 skyehansen

hi, this is just a syntax issue. Your fields always should be encased with curly brackets. So in the above expression, it would have been ADDDAYS({lastUpdateDate},5). That's it.

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
December 27, 2023

hi, this is just a syntax issue. Your fields always should be encased with curly brackets. So in the above expression, it would have been ADDDAYS({lastUpdateDate},5). That's it.

    amybillmayer
    amybillmayerAuthor
    Level 4
    January 2, 2024

    Oh wow. So simple, but I'm so glad I asked. Thank you @skyehansen!

    Terms & ConditionsAccessibility statement

    Loading footer...