Using postgres function on control Parameter

[sulaimanrafiq]

Hi Guys,

 

Apologies if im creating this in the wrong place. Im new to iReports and the site.

 

I am attempting to pass a control date parameter (value entered by the user) into an SQL statement. No problems with that on its own.

 

However, when i try and use the date parameter in a postgres function (for example date($P{end_date}) + interval '24 hours') the function does not like the syntax of the parameter.

 

The syntax im using for the function im pretty sure is fine. I've imported in the postgres jars that i need to use for the function. Any date fields from the database passed in work.

 

Does iReport support type of SQL statement or am I missing something?

 

Thanks in advance for any help offered.

 

Sorry again if this is in the wrong place.

[Giulio Toffoli]

How is the parameter end_date declared? Is it a Date?

In that case, are you sure you need to use the date() function in the query?

 

Giulio