Hello, I need to remove record if Name, and Job_Date are the same, and calculate only the CALC field value is "YES" for each Name stay at their title. For example for EE10, want to calculate Job_date of 16JAN2009 to Job_date 01NOV2011, then we want to calculate Job_date 07DEC2015 to today's date. Thank you for your any assistance. EE10 SPEC V,HR 01MAY2001 EE10 PROJ MGR 01JAN2004 EE10 SUPV IV,ADMIN 16JAN2009 YES EE10 PROJ MGR 01NOV2011 EE10 CONSL,HR STRATEGY & GOVER 06JAN2014 EE10 MGR I,HR 07DEC2015 YES EE10 MGR I,HR 07DEC2015 YES Name Title JOB_DATE CALC EE8 SUPV V 01AUG2011 YES EE8 ENGINEER IV,ELECT 10DEC2012 EE8 MGR I,SYS CONTROL CTR SUP 02MAR2015 YES EE8 MGR I,SYS CONTROL CTR SUP 02MAR2015 YES EE9 GENL MGR,DIVERSIFIED PLAN 11NOV2013 YES EE9 VP,POWER SUPPLY GENERATIO 31AUG2015 YES EE9 VP,POWER SUPPLY GENERATIO 31AUG2015 YES EE10 SPEC V,HR 01MAY2001 EE10 PROJ MGR 01JAN2004 EE10 SUPV IV,ADMIN 16JAN2009 YES EE10 PROJ MGR 01NOV2011 EE10 CONSL,HR STRATEGY & GOVER 06JAN2014 EE10 MGR I,HR 07DEC2015 YES EE10 MGR I,HR 07DEC2015 YES
... View more