I have a table with Salesman' data, incld their assigned commission rate and effective data for that rate. These commission rates change randomly as the salesman move from job to job. when they do change the commission rate changes along with the effective date. I want to find out by how to get there prorated ytd commission rate if I give a random date. The calculation has to take into account based on the date I give how long has this salesman been...