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
TheresaAndersonTheresaAnderson 

Calculate Lead Age

Does anyone have a formula to calculate the Lead Age (creation date - conversion date)?  We are measuring the age of our Lead process.

 

Thank you.

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

Here you go:

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

 

PS.  You owe me a beer! (these terms are non-negotiable)

All Answers

Steve :-/Steve :-/

Here you go:

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

 

PS.  You owe me a beer! (these terms are non-negotiable)

This was selected as the best answer
TheresaAndersonTheresaAnderson

Thank you!!!!
Steve :-/Steve :-/

No problem, I like to drink these ->  http://beeradvocate.com/beer/profile/863/7971
Sales Rapt MediaSales Rapt Media
This is great! Do you implement this forumla in a contact report, lead report or opportunity report?
Danielle DeBenedictisDanielle DeBenedictis
This isn't working for me.... it keeps telling me that the field 'Converted' does not exist. Any ideas??? Does anyone know what 'DB Lead Age' means? It doesn't seem to mean converted minus create date... 
JPSeaburyJPSeabury
Dainelle -- the field name isn't "Converted", it's "IsConverted". Copy and paste the formula string exactly as Steve wrote it -- and don't forget his beer. :-)