You need to sign in to do that
Don't have an account?
Compare picklist values
Hi,
I have Rank field as picklist and having picklist values as:
A1-poor
A2- Below Low
A3-Low
A4-Average
A5-Above Average
A6-below high
A7-High
and having date fields like
date_A1
date_A2
date_A3
date_A4
date_A5
date_A6
date_A7
I need to check if old value is lower and updated value is higher means, then between the other values needs to update today date as higher value date.
for eg: Rank has changed from "A2- Below Low" to "A6-below high" then "date_A6"high is updated by today date and also between
them 3 fields also need update by today date i.e "date_A3,date_A4,date_A5".
It may change the rank from any way. There are 20 picklist values are there.So we can't check every value.
Can any one know how to do this requirement.
Thanks in Advance.
Rajesh.