JDBC_PrepStmt and SQL Server

I'm trying to run a query over a SQL server table to select a count of
records that have records within a specific date range.
The field in the sql server is a date/time field.
I've set up a JDBC_PrepStmt as follows

stmt = JDBC_PrepStmt(connms: 'select * from serviceCards_log +
where convert(char(10,logdate,120) > ?');

JDBC_setString(stmt: 1: begdate);

JDBC_ExecPrepQry(stmt);

Temporarily I've set the field begdate = '2010-01-01'

This is the error I receive
Message . . . . : Java exception received when calling Java
method.
Cause . . . . . : RPG procedure JDBC_EXECP in program QGPL/JDBCR4
received
Java exception "java.sql.SQLException: Line 1: Incorrect syntax near

'logdate'." when calling method "executeQuery" with signature

"()Ljava.sql.ResultSet;" in class "java.sql.PreparedStatement".


How do i debug this to see what the JDBC_ExecPrepQry(stmt) is trying to
execute.?
I'm really not sure if I have the convert setup correctly or if that is
the best way to extract the date from the date/time field.


Thanks
Mike



NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.