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?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Really simple suggestion, but did you try putting curly brackets around the custom field name?
ADDDAYS({Video due date},-3)
Views
Replies
Total Likes
Really simple suggestion, but did you try putting curly brackets around the custom field name?
ADDDAYS({Video due date},-3)
Views
Replies
Total Likes
THAT'S THE ANSWER!!!!
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)
Views
Replies
Total Likes
Try - ADDWEEKDAYS({Video due date},-3)
:-)
Views
Replies
Total Likes
Views
Replies
Total Likes