Add 1 day to the date parameter.

[jinwei.si]

Hi,

I need to query the dataset between selected parameters ${startDate} and ${endDate}. However, the result should contain all the data from the last date as well (until the 24 o clock at endDate instead of 0 o clock).

So I tried to change the query to (I am using DB2):

select * 

from HWE.TRANSACTIONS

where 

CREATED >= $P{startDate} AND 

CREATED <= $P{endDate} + 1 days

 

It gives an error message that the SQL query isn't correct.

I have tried to create a new parameter, that didn't work either.

 

Thank you.

 

[jinwei.si]

On the other hand, the query works when I use "CREATED <= CURRENT_DATE + 3 DAYS" 

Only non-functional when I use the time operation with the parameter

[zuhayer171288]

Here is the answer I got for you from google:
http://stackoverflow.com/questions/1675272/jasper-reports-add-one-day-to-a-date-parameter