Date calculation in form not working | Community
Skip to main content
J
JillAc
Level 10
January 11, 2022
Solved

Date calculation in form not working

  • January 11, 2022
  • 3 replies
  • 1018 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)

3 replies

SarahNau
Adobe Employee
SarahNauAdobe EmployeeAccepted solution
Adobe Employee
January 11, 2022

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

ADDDAYS({Video due date},-3)

J
JillAcAuthor
Level 10
January 11, 2022

THAT'S THE ANSWER!!!!

    J
    JillAcAuthor
    Level 10
    January 13, 2022

    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
    Adobe Employee
    SarahNauAdobe Employee
    Adobe Employee
    January 13, 2022

    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
    Level 10
    January 13, 2022
    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!
    Terms & ConditionsAccessibility statement

    Loading footer...