Client CLSDATE BDSPDT AMT Act Job

XYZ 4/7/2010 4/12/2010 11000.00 IA 0034 1011
XYZ 4/7/2010 4/12/2010 IA 0034 1011
XYZ 4/7/2010 4/12/2010 IA 0034 1011
XYZ 4/7/2010 4/12/2010 IA 0034 1011
XYZ 4/13/2010 4/22/2010 7000.00 IA 0034 1011
ABC 4/7/2010 4/12/2010 10000.00 IB 0038 2011
ABC 4/7/2010 4/12/2010 IB 0038 2011
ABC 4/7/2010 4/12/2010 IB 0038 2011
ABC 4/7/2010 4/12/2010 IB 0038 2011

For a given client, act, job...i need the latest date
OR
For a given client, act, job...i need the difference between BDSPDT - CLSDATE

pls help...thnx...