+ Start a Discussion
Sree SalesforceSree Salesforce 

i have a one picklistfield.picklistfield have 3 values.i want to display how many days between last selected value in picklist and present creating record.i enable field history on picklistfield.how can i achieve this formula

Just to clarify - do you want to show the number of days since the user changed the picklist field?  If so, you can't do this with field history tracking.  Instead you should use a custom field containing the date that the picklist was last amended and set this via a workflow rule when the user changes the value of that field.  Then you can simply have a formula field that displays the number of days between the date in the custom field and today.
Sree SalesforceSree Salesforce
i want to display last selected picklist value created date and present creating record date.between date