Hi,
I have two sets of data. I want to know if the date in one set occurs within the date range in the other set.
Either yes, or no.
Here is my data:
I pretty much would like to add a column to "Data set 1" that says yes or no, yes if the date in data set 1 occurs within the date range of data set two. I understand that there are multiple Well values with different date ranges, thats what makes this hard for me. I have to have the well and its corresponding date range match up with the well and date in data set 1.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
I have two sets of data. I want to know if the date in one set occurs within the date range in the other set.
Either yes, or no.
Here is my data:
I pretty much would like to add a column to "Data set 1" that says yes or no, yes if the date in data set 1 occurs within the date range of data set two. I understand that there are multiple Well values with different date ranges, thats what makes this hard for me. I have to have the well and its corresponding date range match up with the well and date in data set 1.
Data Set 2 | ||
Well | Start date | End Date |
A | 8/12/2014 | 8/12/2014 |
A | 8/12/2014 | 8/12/2014 |
A | 8/12/2014 | 8/12/2014 |
A | 10/2/2014 | 11/5/2014 |
A | 8/12/2014 | 9/1/2014 |
B | 8/24/2013 | 3/15/2015 |
B | 8/24/2013 | 3/15/2015 |
C | 12/25/2013 | 3/15/2015 |
C | 12/25/2013 | 3/15/2015 |
C | 12/25/2013 | 3/15/2015 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Data Set1 | |
Well | Date |
A | 12/1/2014 |
A | 11/1/2014 |
A | 10/1/2014 |
A | 9/1/2014 |
B | 12/1/2014 |
B | 11/1/2014 |
B | 10/1/2014 |
B | 9/1/2014 |
B | 5/1/2014 |
B | 4/1/2014 |
B | 3/1/2014 |
B | 2/1/2014 |
B | 1/1/2014 |
B | 12/1/2013 |
B | 11/1/2013 |
B | 10/1/2013 |
B | 9/1/2013 |
B | 8/1/2013 |
B | 5/1/2013 |
B | 4/1/2013 |
B | 3/1/2013 |
B | 2/1/2013 |
B | 1/1/2013 |
B | 12/1/2012 |
B | 11/1/2012 |
B | 10/1/2012 |
B | 9/1/2012 |
B | 8/1/2012 |
B | 7/1/2012 |
B | 6/1/2012 |
B | 5/1/2012 |
B | 4/1/2012 |
B | 3/1/2012 |
B | 2/1/2012 |
B | 1/1/2012 |
B | 12/1/2011 |
C | 12/1/2014 |
C | 11/1/2014 |
C | 10/1/2014 |
C | 9/1/2014 |
C | 8/1/2014 |
C | 7/1/2014 |
C | 6/1/2014 |
C | 5/1/2014 |
C | 4/1/2014 |
C | 3/1/2014 |
C | 2/1/2014 |
C | 1/1/2014 |
<colgroup><col><col></colgroup><tbody>
</tbody>