Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Converting a SQL Command Parameter from Date to Char

Hi,

I'm using CR XI version 11.0.0.1282. I've created a report using a SQL Command and have a parameter defined as Date. I need to convert this Date parameter to a CHAR and have created my WHERE clause as:

WHERE "CC_PAYH"."PPOST"= CHAR ('{?From Date}') AND

"CC_PAYH"."PPTYPE"<>13

I get a message saying 2008 is not a valid token which in AS400 means it doesn't like the year. Go figure.

I've tried running a similar query in AS400 and I get the desired affect. I've tried removing the parameter from the Where clause and putting it into the Select like:

CHAR ('{?From Date}') as MyTestDate

just to see the representation I would get and I get the same error.

The question I have like everyone else is; is this possible with this version of Crystal? I assume so since the same query will work in the database itself.

Thanks,

Brian

Not what you were looking for? View more on this topic or Ask a question