Re: SQL Date Comparison Using ODBC Connector

2009-09-08 Thread Ashton, Jim (JUS)
You may need to try some dynamic SQL. In Books Online (assuming SQL Server), look up "EXECUTE", paying special attention to the section on "Using EXECUTE with a Character String". This will allow you to dynamically add the date value you require to a SQL statement and execute it. Something li

SQL Date Comparison Using ODBC Connector

2009-09-04 Thread JanetB
SQL Server - I am using the ODBC connector, so it does not appear I need to do the date conversion functionsm, although I tried those as well with no success. -- View this message in context: http://www.nabble.com/SQL-Date-Comparison-Using-ODBC-Connector-tp25296607p25296607.html Sent from t