I have a problem.
I have a start date refers to an article and I must be able to calculate the end date for that item.
is a bit difficult to explain socarry two examples.
The first table is what I have.
the second table is what I would like to find.
in the second table is the end date column that calculates the end date of interval.
thanks
| start Data | Art Father | Art Son | Type |
|
| 01/10/2010 | A11 | A1131 | 1 |
|
| 01/10/2010 | A11 | A1145 | 1 |
|
| 01/10/2010 | A11 | A1146 | 1 |
|
| 02/09/2010 | A11 | A1146 | 3 |
|
| 02/09/2010 | A11 | A1145 | 3 |
|
| 02/09/2010 | A11 | A1146 | 3 |
|
| 02/09/2010 | A11 | A1100 | 3 |
|
| 02/09/2010 | A11 | A1185 | 3 |
|
| 01/01/2010 | A11 | A1185 | 100 |
|
| 01/01/2010 | A11 | A1103 | 100 |
|
| 01/01/2010 | A11 | A1158 | 100 |
|
| | | |
|
| | | |
|
| start Data | data end | Art Father | Art Son | Type |
| 01/10/2010 | 10/10/2010 | A11 | A1131 | 1 |
| 01/10/2010 | 10/10/2010 | A11 | A1145 | 1 |
| 01/10/2010 | 10/10/2010 | A11 | A1146 | 1 |
| 02/09/2010 | 31/09/2010 | A11 | A1146 | 3 |
| 02/09/2010 | 31/09/2010 | A11 | A1145 | 3 |
| 02/09/2010 | 31/09/2010 | A11 | A1146 | 3 |
| 02/09/2010 | 31/09/2010 | A11 | A1100 | 3 |
| 02/09/2010 | 31/09/2010 | A11 | A1185 | 3 |
| 01/01/2010 | 01/02/2010 | A11 | A1185 | 100 |
| 01/01/2010 | 01/02/2010 | A11 | A1103 | 100 |
| 01/01/2010 | 01/02/2010 | A11 | A1158 | 100 |
