Invalid datetime format

[RMK12345]

After upgrading from CF4 to CFMX7 we are getting this error on any date field
that we're trying to pull in a query.

Error Executing Database Query.
Invalid datetime format.

These pages and queries worked fine in 4, nothing has been changed in the
source code or database sturcture.
It is an Oracle database.

Any help would be greatly appreciated.
Becky

[Dan Bracuk]

use the createodbcdate function and you'll never have to worry about date formats.

[RMK12345]

How would the createODBCdate function help in this query?

SELECT A.adminID, S.lName, S.fName,
MAX(a.reqdate) as reqdate,
MAX(H.accDate) as lastAcc
FROM #theOwner#ML_ssoadmin A, #theOwner#ML_student S, #theOwner#ML_hits H
WHERE A.adminID = S.sso AND A.adminID = H.sso(+)
GROUP BY A.adminID, S.lName, S.fName
ORDER BY S.lName, S.fName

I have discovered that I'm getting the error on queries that have nulls in a
date field.

[RMK12345]

Found the fix!!!

We were using the ODBC drivers to connect to the Oracle db.
We changed to connecting with the thin client and it works now, null date
fields and all!

I hope this helps someone out there.