my date data range are not visible in vib chart!

Tweet

hi all, im using MSchart and vb6 to make a chart, what im making is a chart that filled with date data such as 3/1/2006 to 3/31/2006. what annoy me is i managed to plot the chart but in X-axis legend the date arent show. and one more think when i plotted data for 3/1/2006 to 3/31/2006 , it should present me with 31 data but instead it shows only 30 data. im using SQL to set my data range rs.Open "Select S1,S2,S3,S4,Q from test2 where [Name Pa] ='" & x & "' and Dates between #" & start & "# and #" & end & "# ORDER BY Dates ASC", cn, adOpenDynamic, adLockOptimistic please someone help me thanks