Hi everybody,

I created a custom field that shows me for how long the status of a lead has been on "open". Now I want to be informed by mail as soon as a lead (or even better: a group of leads) exceeds a specified time span the lead has been on "open". 

Does anybody of you have any idea how this can be done?

Thanks in advance for your support.

Tim

How do I capture the duration of the status for reporting purposes? 

Ex:

A lead has open, working, closed status.  It's opened on Sept 1st  for 10 days switchs to working for 8, than closed till now. How do I track and record the duration of each status?

Is this achievable in Salesforce, if so do i need a formula?

-Hkp716