Timeline splitup logic

[satheesh_color]

Hi,

I will need to splitup the dates as there are overlapping

Type Start Stop
---------------------------------------------
C 01/01/2011 01/31/2011

B 02/01/2011 05/31/2011
C 03/01/2011 08/31/2011
D 05/01/2011 10/31/2011
B 09/01/2011 12/31/2011


Since there are overlaps, the timeline needs to be split as follows:

Start Stop active
---------------------------------------------
01/01/2011 01/31/2011 C only
02/01/2011 02/28/2011 B only
03/01/2011 04/30/2011 B, C
05/01/2011 05/31/2011 B, D, C
06/01/2011 08/31/2011 C, D
09/01/2011 10/31/2011 B, D
11/01/2011 12/31/2011 B only


kindly let me know your thoughts.

Thanks,
Satheesh.R

[ray.wurlod]

Have you analysed your logic and written out an algorithm? What have you already tried?

Or are you just expecting us to do your work for you?