Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Date calculation in form not working

Avatar

Level 10

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee

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

ADDDAYS({Video due date},-3)

View solution in original post

5 Replies

Avatar

Correct answer by
Employee

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

ADDDAYS({Video due date},-3)

Avatar

Level 10

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)

Avatar

Level 10
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!