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

    What function to use? Simple Problem!



      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.