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
Ken sfdc1Ken sfdc1 

Calculate days of picklist value change

 I need a calculating field ---  calculate days taken to change from open to verified status.

There is a Lead Status picklist  on Account object   -- open ---> Verified.
.
Let me know if you need more info.
Best Answer chosen by Ken sfdc1
Lokesh KumarLokesh Kumar
HI Ken,

You can achieve this by SOQL Query on Account__HISTORY Object like [Select OldValue,NewValue from Account__HISTORY where Field = 'Lead_status' ];

Thanks !

All Answers

Ken sfdc1Ken sfdc1
And I have a audit trial on this field too, I can see in Account History.
Lokesh KumarLokesh Kumar
HI Ken,

You can achieve this by SOQL Query on Account__HISTORY Object like [Select OldValue,NewValue from Account__HISTORY where Field = 'Lead_status' ];

Thanks !
This was selected as the best answer
LBKLBK
A before update trigger on Account object could do the trick for you.