+ Start a Discussion
SRajesh8SRajesh8 

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.