Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Identifying the last break in employment

    Hi,

    I need to identify the last break in employment for each individual.

    Each individual has a unique identifier but has had a number of separate jobs, there could be gaps in employment or overlaps. I need the oldest start date of the continuous employment.

    In the (simplified) example below, the date I'm interested in is Feb 6th (because there was a break in employment on the 5th Feb)


    I can easily change the layout to be in 3 colums (where each job is a searate row), if that helps.

    Thanks in anticipation!

    Jim
    (Shetland Isles)
    Last edited by jmacleod; 2012-06-14 at 06:21. Reason: Table isn't showing correctly

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post
    Sorry, couldn't get the table to display:

    01245
    From 2nd Jan to 4th Feb
    From 6th Feb to 12th Aug
    From 16th Sep to 10th Oct
    From10th Aug to 21st Nov
    From 22nd Nov to 25th Dec

    This is all in one row like

    ID, Start, Finish, Start, Finish, Start, Finish etc (maximum 25 jobs per individual)

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post
    Thanks to all who looked. I've solved it with some horrible code that's too embarrassing to share here.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •