You need to sign in to do that
Don't have an account?
Jason 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) )))
Couldn't this be simplified to:
IF (ISNULL ( ConvertedDate ), null,
ConvertedDate - DATEVALUE(CreatedDate) )