You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am attempting to calculate the difference between two custom fields (in days) and populate the result into a number field.
See screenshot below for what I have entered.
I get an error message which states "Additional fields contains invalid field(s) in 'update' or 'fields' section: Custom Field Name" but this does not tell me at all where the issue is. I have tried various variations but get no where.
Thanks for your help.
Hi @Dave Jones
I recreated this, using the Start Date and End Date fields, and using this smart value:
^ And it worked as expected.
What does the rest of your rule look like? Are these both Date Picker fields?
Thank you for your quick response. I have tried the same as you entered but it still does not work for me:
Below are the screenshots of the custom fields so you can see their IDs:
Here is the rest of the rule, but there does not seem to be anything unusual? I should explain I am very new to this so I am probably missing something basic.
Hi @Dave Jones and welcome to the community,
Are these two custom field date fields? From the looks of it, the second field, to which you have append the suffix .value, isn't a date field. So I'm not sure you can calculate the difference in days.