Date calculation in form not working

Forum|Forum|4 years ago
January 11, 2022
3 replies
1006 views

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?

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 SarahNau

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

ADDDAYS({Video due date},-3)

J

JillAcAuthor

New Participant

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

Employee

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

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus

:-)

J

JillAcAuthor

New Participant

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!

J

JillAcAuthor

New Participant

THAT'S THE ANSWER!!!!

SarahNauAccepted solution

Employee

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

ADDDAYS({Video due date},-3)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded