sadique Report post Posted February 4, 2010 (edited) How to get data from database for gantt chart.(Need sql query for exist/missing data for whole year). Like i go for year 2010 and find startdate as 02-03-2010(mm-dd-yyyy) and enddate 04-04-2010. So for above example how i get remaining data for given year. Thanks in advance. Edited March 2, 2010 by Guest Share this post Link to post Share on other sites