Ok, let me explain again,
When I configured my pen in Easy Chart, appears the next popup window error:
[b]Gateway Error 301:
SQL Error: La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
For Query: SELECT t_stamp FROM Cortes WHERE t_stamp >= ‘2008-07-30 00:00:00’ AND t_stamp <= ‘2008-08-29 23:59:59’ ORDER BY t_stamp
On: Window 1.Root Container.Easy Chart
[/b]
I have converted the date field to char in the WHERE Option in Easy Chart, and now appears the next popup window error:
[b]Gateway Error 301:
SQL Error: La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
For Query: SELECT t_stamp, Cortes, Rechazos FROM Cortes WHERE t_stamp >= ‘2008-08-27 00:00:00’ AND t_stamp <= ‘2008-08-29 23:59:59’ AND (LEFT(CONVERT(varchar,t_stamp,120),10)>= ‘2008-08-27 00:00:00’) AND (LEFT(CONVERT(varchar,t_stamp,120),10)<= ‘2008-08-29 23:59:59’) ORDER BY t_stamp
On: Window 1.Root Container.Easy Chart
[/b]
When I executed the “Run Diagnostics” button in some pen edition, display the next information:
[b]Table ‘Cortes’ exists.
Time Column ‘t_stamp’ exists.
Time Column ‘t_stamp’ is the correct type.
Time Column ‘t_stamp’ is indexed.
Value Column ‘Rechazos’ exists.
Value Column ‘Rechazos’ is the correct type.
Results: 0 Warnings, 0 Errors [/b]
Best Regards