Jump to content
  • 0

Consolidate dates to date ranges




I've got an old database application that recorded staff roles by date. For each month of a staff member's employment, a role was recorded as well as the date as YYYY-MM.

This is what the data looks like:

LastnameDescending   Position Start Date
Homer   CEO 2010-07
Homer   CEO 2010-06
Homer   COO 2010-05
Homer   COO 2010-04
Homer   COO 2010-03
Homer   CFO 2010-02


In the new CASPIO application, roles are recorded with a start and end date.

What is the easiest way to transform the old format to the new one and consolidate so that it looks like the table below?

LastnameDescending Position Start Date End Date
Homer CEO 01.06.2010 31.07.2010
Homer COO 01.03.2010 31.05.2010
Homer CFO 01.02.2010 28.02.2010


Many thanks, Christian




Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...