Thank you.

I tweaked it a little and implemented this for my case and it worked.

Thanks Kevin ... this worked for me .. i have a function in place to reformat the start date and enddate to a month end date... So i should be...

Thanks Luis for guiding me ...

i made some changes like i am on SQL 2008 and Eomonth function is not available to me so i used date functions to...

Thanks Robert for the pointer.The issue was with the column visibility. i figured it out after reading through your reply.

thanks alot

Evil Kraig F for pointing out that ... it was silly of me to overlook that....

i have another issue related to this package ... i need to create...

thanks sean ... i will give it a try .....