Recent content by ltalbott

Hi Vonnie The records would be as follows: Start Date End Date No of Days Joe Bloggs 6/1/2009 11/1/2009 6 Joe Bloggs 12/1/2009 18/1/2009 7 Joe Bloggs 19/1/2009 19/1/2009 1 Not all cases in the raw data would produce more than one...

Hi I have been asked to do some complex analysis on absence management. The problem is our HR System reports absence by each week. So for example someone who has been off for 5 weeks will have 5 different records, but these are continuous (eg.1st record starts on Monday and finishes Sunday...