• 5 Points
  • Member since 2004

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 1
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?
  • March 22, 2007
  • Like
  • 0
help, I want to create a new custom field LEAD AGE on Lead Page, any idea about formula I have to use to know how many days each lead has since creating.thanks