Kudos to Bill M. on this... meswi01
Per Bill:
You need to have 2 parameters: pOpenDateMin of type java.sql.Date and pOpenDateMinStr (or whatever you want to call it), type java.lang.String. Set the default value for pOpenDateMinStr to DATEFORMAT($P{pOpenDateMin}, "yyyy-MM-dd HH:mm:ss"). That converts the date value to a string in the timestamp format. Then your query should look like this:
SELECT
ref_num, open_date
FROM cr
where open_date > {ts'$P!{pOpenDateMinStr}'}
and the ODBC driver handles the rest of the conversion.
No Need for any sort of sub-report sillyness. Bravo Bill!
Still not exactly awesome since we still have to jump through a few hoops to get the two platforms to speak but it's better than where I was about 20 mins ago with it coughing up errors.