function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NYCMeghanNYCMeghan 

Calculating a numerical value based on date fields

I'm trying to create a value that tells me how long my salespeople are taking and how efficient they are in developing contact with their leads.  Basically I need a formula that tells:

LastActivityDate - CreatedDate

But I can't seem to subtract dates and get a value

Help!
Harry JamesHarry James

Those two fields are different data types.  LastActivityDate is a date field, whle CreatedDate is a date/time field.

Try:

LastActivityDate - DATEVALUE(CreatedDate)

 
NYCMeghanNYCMeghan
thanks for the clarification!  Much appreciated