how to use Between in ireport

[icaros91]

How about, my problem is I want to generate a report of such date to such date, the query I have in that part of the Between is like this:

to_char (date, 'dd-mm-yyyy') Between $ P {date} and $ P {date1}

not mark me wrong but I sum data are not.

[spierepf]

What types are the date field and the date and date1 parameters? I suspect that converting the date field to a character string will cause you some grief.

[icaros91]

from what I do is send these parameters java

 

Map parameter = new HashMap ();

                

         parametro.put ("date", day + "-" + month + "-" + year);

parametro.put ("date1", day + "-" + month + "-" + year);

 

where the variables day, month and year I get a combobox in java, and in ireport I do is get in this way

 

TO_CHAR (date, 'dd-mm-yyy') Between $ P {date} and $ P {date1}

 

if I do it separately if you do it correctly, for example:

TO_CHAR (date, 'dd-mm-yyy') = $ P {date}

 

but if I do it with me sum values ​​BETWEEN statement.

and try it with operators> =, <= and I also sum ​​values

[icaros91]

sorry for you see all along the letters but also Climbed

[honeybakliwal]

 

 

Select * from

where

DATEADD(second,19800, dateadd(second,"", 'Jan 1, 1970'))

between $P{StartDate} and $P{EndDate}

 

here data is in epoc time that is in INTEGER datatype

 

Hope this can help ..........:)

 

Regards

Honey