really struggling including date selection in report HELP PLEASE

[george_17]

Hi all

in sheer frustration i stripped my query into simple terms...

steps

i created the report initially without the where statement just to make sure all data was generated...

then i created a Parameter renamed it as Message and set datatype to java.sql.Date

the date_added field on the database is datetime the content looks like 22/08/17 10:30

but this sql  select order_id, comment, date_added from oc_order where cast($P(Message) as datetime) > date_added

asks me to select a date from thecalendar 01/08/17 but pressing the run button i get

error generating report

and in the error log i get exception error executing sql statement for 1.

 

I am hoping someone can make some suggestions as to what i am doing wrong....

 

thanks very much

 

george

 

 

[mlopez_1]

Try using:

where $P{Message} > date_added

Using {} and not ()

If not, use $P{Message} as java.sql.Timestamp

Mariano

[george_17]

Mariano

{} .... SUPERB ... PERFECT

thank you sooooo much !!!

 

george