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
VickiTVickiT 

Formula needed to return number of days from Lead Creation to Conversion

I need to have a formula field that returns the number of days between Lead Creation date and Lead conversion Date.

 

Thanks for your help.

VickiT

Steve :-/Steve :-/

Here you go (don't say I never gave you anything)

 

IF(NOT( IsConverted ), TODAY() - DATEVALUE(CreatedDate), ConvertedDate - DATEVALUE(CreatedDate))