birt report date parmeters problems

hi

i am using birt 2.2.2.
Basically every time i create a report that is controlled via date parameters i run into trouble, the dates never seem to work for me.

I have defined date parameter as follows:
Custom: dd-MM-yyyy

in sql query i have tried the follwing:

Date(orderdate) = ?
Date_Format (orderdate,'%d-%m-%Y' ) = Date_Format(?,'%d-%m-%Y')

I have other reports working with this, but it really fustrates me as depending on differnt reports I have to mess around with date functions untill it works.

Hope somone can help here!
Thanks
stephen

Find more posts tagged with

Comments

Virgil Dodson

Hi stephen, does it need the single quote for your database?<br />
<br />
maybe: Date(orderdate) = '?'<br />
<br />
I made an example once where I had to modify the query directly with the data parameter. The example is located at <a class='bbc_url' href='http://www.birt-exchange.org/forum/deploying-integrating-birt-report-engine-applications/16996-exception-birt-viewer-date-paramater.html'>http://www.birt-exchange.org/forum/deploying-integrating-birt-report-engine-applications/16996-exception-birt-viewer-date-paramater.html</a> and the code is inside the property binding tab of the dataset.