Iam building graphs from SQL. How can i go about retrieving only the current dates data instead off all of the data. Currently using objRS.Open "select * from Power order by Time".
what data type do you have for Time in db,also what format do you use to insert data for Time field ??<BR>
it's something like<BR><BR>SELECT * FROM YOURTABLE WHERE MONTH(DATE_FIELD) = 7 AND YEAR(DATE_FIELD) = 2001 AND DAY(DATE_FIELD) = 1