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
Book_GuyBook_Guy 

Calculate Difference Between 2 Dates

Hi All

 

Does any one know how to calculate:

 

Today()-CreatedDate

1/5/2010 -1/2/2010 = 3

1/1/2011-12/31/2010=1  (regardless of the times, this answer will always be 1)

 

Trying to take the time out of the calculation, just look at the two dates and subtract them. 

 

TIA

 

--David

*werewolf**werewolf*

That's not so hard actually, it's just a formula field like

 

TODAY() -  DATEVALUE ( CreatedDate )
jpatrickpatrick76jpatrickpatrick76

I am trying to return a numeric value for an equation such as:

 

Today() - Datevalue(LastActivityDate) = A Number

 

I have set the return Type to Number