Date calculation in form not working | Community
Skip to main content
JillAc
Level 10
Jan 11, 2022 4:06 PM UTC
Solved

Date calculation in form not working

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.
SarahNau
SarahNauAccepted solution
Employee
Jan 11, 2022 5:33 PM UTC

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

ADDDAYS({Video due date},-3)

View reply

5 replies

JillAcAuthor
Level 10
Jan 13, 2022 6:17 PM UTC

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)

Translate
SarahNau
SarahNau
Employee
Jan 13, 2022 6:25 PM UTC

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

:-)

Translate
JillAcAuthor
Level 10
Jan 13, 2022 6:41 PM UTC
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!
Translate
JillAcAuthor
Level 10
Jan 11, 2022 5:59 PM UTC

THAT'S THE ANSWER!!!!

Translate
    SarahNau
    SarahNauAccepted solution
    Employee
    Jan 11, 2022 5:33 PM UTC

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

    ADDDAYS({Video due date},-3)

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...