8 Replies Latest reply: Oct 5, 2011 1:24 PM by yaman1510 RSS

    What function to use? Simple Problem!

      Hi,

       

      I have 3 fields

      Name,Granted_Date, ManagerName.

       

      I want to display the value of field 'ManagerName', based on the the values of Name and Granted Date. suppose I select a 'Name', it has only one granted date but multiple managers name. I want to display only that manager name who was the manager at the granted date and not the whole list of multiple managers associated with that name.

       

      Thanks . Any help would be appreicated.