Before You Begin
You must have administrator access to create and configure custom fields.
Both source fields must already exist in your module and be set to the Date or Date/Time field type.
Your output (target) field must be created and set to the Integer or Number field type — not Text — so the result is stored as a numeric value.
Steps
Navigate to the custom field expression builder. Go to the module where your date fields and output field are located (e.g., Intake Opportunities). Open the field configuration for your target output field (e.g., Days Between Submission and Response Date).
Set the output field type to Integer or Number. At the top of the field editor, find the Select Field Type dropdown. Change it from Text to Integer or Number. This ensures the calculated result is saved as a number, not a text string.
Open the expression formula box. Locate the expression or formula input area within the field configuration.
Insert your first date field. Use the --Use Field-- dropdown to select your first source date field (e.g., Prior Auth - Date Submitted). This inserts a field reference into the formula box.
💡 Tip: The --Use Field-- dropdown is simply a shortcut to insert field references into the formula. You are not limited to one field — you can reference multiple fields in a single expression.
Type a comma in the formula box. After the first field reference is inserted, manually type a comma (,) directly in the formula box to separate the two arguments.
Insert your second date field. Use the --Use Field-- dropdown again to select your second source date field (e.g., Insurance Response Date). This inserts the second field reference after the comma.
Wrap both fields in the time_diffdays() function. Edit the formula box so that both field references are wrapped in the following syntax:
time_diffdays(field_1, field_2)
Replace field_1 and field_2 with the actual field references inserted by the dropdown. The final expression should look similar to:
time_diffdays({Prior Auth - Date Submitted}, {Insurance Response Date})
Save the field configuration. Click Save to apply the expression to your output field.
Verification / Expected Result
Once configured, the output field (e.g., Days Between Submission and Response Date) will automatically calculate and display the number of days between the two date fields as a whole number. For example, if the submission date and response date are 25 days apart, the field will display 25.
✅ Best Practice: Test the expression on a record where both date fields are already populated to confirm the calculation returns the expected result before rolling it out to your team.
Troubleshooting / Common Errors
Expression not calculating / returning an error: Verify that both source fields are set to the Date or Date/Time field type. The time_diffdays() function does not work with Text fields.
Result showing as text instead of a number: Confirm that the output field type is set to Integer or Number, not Text. You may need to update the field type and re-save.
Only one field appearing in the formula: Remember that the --Use Field-- dropdown is a shortcut — you can use it multiple times in one expression. Select the first field, type a comma, then select the second field from the same dropdown.
Output field is empty: Check that both source date fields contain values on the record you are testing. If either field is blank, the expression cannot calculate a result.
Related Resources
⚠️ Note: Screenshots from Dazos/iCampaign (via Scribe) still need to be inserted at each step before publishing.