+ Start a Discussion
Jason L.ax300Jason L.ax300 

Formula for calculating days to convert a lead - solution

I searched the board here and couldn't find a solution but ended up coming up with one myself.  We needed to know what our average time was (in days) to convert a lead.    Since our CreateDate for leads was a DATE field and our ConvertedDate was a DATETIME field, doing a simple  {converteddate} - {createddate} wouldn't work.
 
Anyway, here's the formula I used, hopefully it's useful to others...
 
(DATE(YEAR(ConvertedDate ),MONTH(ConvertedDate ),DAY(ConvertedDate ))) - (DATE(YEAR( DATEVALUE(CreatedDate) ),MONTH(DATEVALUE(CreatedDate) ),DAY(DATEVALUE(CreatedDate) )))
Harry JamesHarry James

Couldn't this be simplified to:

IF (ISNULL ( ConvertedDate ), null,
ConvertedDate - DATEVALUE(CreatedDate) )

 

Jason L.ax300Jason L.ax300
even better...thanks!