Date formats in parameters

[jimmarkham]

Crystal 8.5
Oracle 7.3.4 database
ODBC connection on Windows 95

Does anyone know whats happening here please.

I create a report in Crystal with a parameter that is type date or datetime. The parameter is to be used in the selection criteria and so gets passed into the query syntax.

When I run the report it requests the parameter in the usual way but then errors with an Oracle syntax error.

The Oracle error is ORA 1830 date format picture ends before converting entire input string.

Looking at the query it shows:

SELECT
DATES."CALDATE"
FROM
"PIMS"."DATES" DATES
WHERE
DATES.&quot;CALDATE&quot; < {ts '2003-03-07 14:24:07.00'}

I'm new to Crystal 8.5 so I don't know whether this is correct or not. It's certainly not Oracle syntax. Do I have a configuration problem or something?

Any suggestions anyone.

Thanks

Jim Markham

 

[synapsevampire]

Make sure that you use the CR supplied ODBC driver.

Try retrieving the value of your date field and examine it's contents, perhaps it has a custom format.

-k

 

[jimmarkham]

Thanks synapsevampire.

You are correct. Changing the ODBC driver has fixed the problem.

Cheers

Jim