Date calculation in form not working

[JillAc]

Trying to make a calculated date based on another form field. I'm using Calculated Field, format=date

"Video due date" is a date field in the same form. This is the calculation I'm using that comes back "Custom Expression Invalid"

ADDDAYS(Video due date,-3)

Anybody know what I'm doing wrong?

[SarahNau · Accepted solution]

Really simple suggestion, but did you try putting curly brackets around the custom field name?

ADDDAYS({Video due date},-3)

[JillAc]

THAT'S THE ANSWER!!!!

[JillAc]

Now to get more sophisticated. How can I make a calculated date field on a custom form that will skip weekends?

This is my formula:

ADDDAYS({Video due date},-3)

[SarahNau]

Try - ADDWEEKDAYS({Video due date},-3)

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...

:-)

[JillAc]

Ok DUH thanks, I had given up on being able to understand that section after I couldn’t figure it out from my last question. I need to slow down. Thanks!