Hi
This has got me quite confused.
Getting the following error from a very simple query :
Error opening Data Source: ERROR [22007][Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
This is the query.
SELECT SUM(md_value ) FROM mi_data join data_items ON md_di_id = di_id WHERE di_dt_id = 6 AND datediff(day, md_date, '16/05/2004' ) = 0
Now I'm not connecting to the db via QA, but another query builder. The weird thing is that it works fine on a colleagues machine (aslo with the other query builder)!?! Checked the ODBC settings and they all match.
Any ideas?
Thanks
Ritch
"I didn't do anything it just got complicated" - M Edwards