Hi, I am using TChart Pro ActiveX V5.0.3 - with VB6 against a MySQL database using ODBC 3.51.07. When I get the data using the following query "SELECT Date, P1 from mytable" all is ok, but as soon as I use a summary function to get average values as "SELECT CONCAT(SUBSTRING(Date,1,13),'.00.00') as D...