DIFFINDAYS function error - tried common solutions

(0) Share

Report

Posted on by Ben T

789

Hi,

So I am trying to calculate the difference in days between two custom fields. Both fields are set to user local and "date and time."

I have not put the fields into a form yet, as I made the two fields right before attempting to make the calculated field.

I've attached a picture of the error - any help would be appreciated. I've used this formula before with no issues, so really unsure of what's going on.

*This post is locked for comments

All responses (3)

Answers (1)

Ben T 789 on at

Like (0)

Report

RE: DIFFINDAYS function error - tried common solutions

Omg...wow. Simplest fix I've ever experienced with the CRM. Thanks!!
Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: DIFFINDAYS function error - tried common solutions

Hello Ben,

Try to use , instead of - between fields like

DIFFINDAYS(field1, field2)
Ben T 789 on at

Like (0)

Report

RE: DIFFINDAYS function error - tried common solutions

I also have the calculated field set to whole number.