+ Start a Discussion

Lead Age calculation not based on create date

My scenario is slightly different - and I'm wondering if you can help. I am trying to calculate the age of an "Open" lead. I found some in the sample formulas - If(ISPICKVAL(Status, "Open"), Round(NOW()-CreatedDate,0),Null) but - an "open date" could be after the create date. I thought perhaps using last modified would help- but that wouldn't do it. Is there a date field associated with Lead History? Thoughts?


Are you able to find any solution? I've to do the same thing. I need to measure how many days Leads is in open/contacted status separately.


Any help would be greately appreciated.