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
Timeline splitup logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
Timeline splitup logic
Last edited by satheesh_color on Thu May 10, 2012 12:47 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: