Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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!