twilliamson2
MIS
I am using CR X with an Oracle DB. I am trying to create a identifier for employees that had two or more positions during the same time period. In order to do this, I need to compare dates ranges within a set of records, which is the start date and end date.
For Example:
If Beth Jones worked as a Teacher with a start date of 1/1/2008 and an End date of 12/31/2008. In addition, Beth Jones worked a second job (part-time) as a Counselor with a start date of 2/1/2008 and an End Date of 7/31/2008. In this case, you can see that Beth worked 2 jobs during the same time. How do I create an identifier for these types of records?
Here are the sample records:
Name: Beth Jones
Job Start Date End Date
Teacher 1/1/2008 12/31/2008
Counselor 2/1/2008 7/31/2008
Please help!
For Example:
If Beth Jones worked as a Teacher with a start date of 1/1/2008 and an End date of 12/31/2008. In addition, Beth Jones worked a second job (part-time) as a Counselor with a start date of 2/1/2008 and an End Date of 7/31/2008. In this case, you can see that Beth worked 2 jobs during the same time. How do I create an identifier for these types of records?
Here are the sample records:
Name: Beth Jones
Job Start Date End Date
Teacher 1/1/2008 12/31/2008
Counselor 2/1/2008 7/31/2008
Please help!