ADDDAYS function not working?

[amybillmayer]

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!

[skyehansen · Accepted solution]

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]

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