nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get result set to include data for an EndDate parameter?

cletehayes

I have a simple report to allow users to see what has been billed to their account for a specific period of time. The user is prompted to enter a StartDate and an EndDate parameter. However my result set does not include transactions which occur on the EndDate. It acts like (EndDate - 1). How do I get BIRT to include EndDate transactions? Any advise would be appreciated. Clete

Find more posts tagged with

Comments

kclark

What does your SQL statement look like? It should look something like this<pre class="_prettyXprint">select *from paymentswhere paymentdate >= ? and paymentdate <= ?</pre>

bgbaird

If you want to include the end date, you might try something like this (SQL Server) select *
from payments
where paymentdate >= ? and ? > dateadd(dd,1,paymentdate)

bgbaird

You caould also throw this JS in the report initialize script. params["EndDate"].value=BirtDateTime.addDay(params["EndDate"].value,1); Brian

Hans_vd

Hi, The dates in your data source probably have a time component in them.Take a look at this post: <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/30523-how-do-i-get-result-set-to-include-data-for-an-enddate-parameter/'>http://www.birt-exchange.org/forum/index.php?/topic/30523-how-do-i-get-result-set-to-include-data-for-an-enddate-parameter/</a>

Hans_vd

What?That post is also created by you?Was it not helpful?