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
but - an "open date" could be after the create date. I thought perhaps last modified - but that wouldn't do it. Is there a date field associated with Lead History?
Thank you so much. It worked.
Kasia
I am trying to calculate the age of an "Open" lead.
I found some in the sample formulas -
If(ISPICKVAL(Status, "Active - Working"), Round(NOW()-CreatedDate,0),Null)
but - an "open date" could be after the create date. I thought perhaps last modified - but that wouldn't do it. Is there a date field associated with Lead History?
Thoughts?
Thank You!! This worked perfect
Thanks in advance