function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ramkramk 

how to calculate time difference between 2 picklist values

Hi

 

i have a picklist <availability__c : custom field> which has values<availabile,offline>. i need to calculate the time difference

between the 2 picklist values when the user changes the availability between these 2 values .how can i do this???

thanks

kiranmutturukiranmutturu
i think u can
create a formula filed and fill the value of lastmodifieddate on that field if any one of the value selected by the user. This is your first reference to calculate diff. After this u need to create an another field to get the diff in the change in the picklist value. And the formula should be diff between lastmodifieddate and formula field if picklist value is changed