function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Lead Age- custom field

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
Harry JamesHarry James
NOW() - CreatedDate or
TODAY() - DATEVALUE( CreatedDate )
Should return the same value.

Thank you so much. It worked.


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, "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?


Thank You!! This worked perfect

Abhishek Trikha 11Abhishek Trikha 11
Round(NOW()-CreatedDate,0),Null.    What is the use of Round, zero & Null? Please explain
Thanks in advance