I am facing another challenge. I tried to make the code work with no success. the issue i am facing is, i need to fill gaps also,

if the year is not completed example :

( 1, 1, 'test1', 'chk', '2/1/2012', '3/1/2012' ),

( 2, 1, 'test1', 'chk', '3/2/2012', '6/30/2012' ),

( 3, 1, 'test', 'chk', '8/2/2012', '12/01/2012' );

the year should always start at 1.1.2012 and end 12.31.2012 and if there is a keep needs to be filled up, so in this scenario i am missing 1.1.2012 to 1.31.2012

7.1.2012 to 8.1.2012 (Which already fixed thanks to Erin)

12.2.2012 to 12.31.2012