Problem by using dates as parameter in my Jasper Server

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email with questions or issues requiring TIBCO review or response.

Hi Jasper fans,

on my jasperserver, i have a report with two date ( parameters (StartDate, EndDate). I want to execute the report by using the rest-interface

I want to pass the date with the time-information: like StartDate=1997-01-01T04:05:06+02:00 with my rest-interface.

Unfortunately, the report shows the StartDate with format: DATEFORMAT($P{StartDate},"yyyy-MM-dd HH:mm:ss")  = 1997-01-01 00:00:00

So, the time information is gone. Any advice to receive the time information?

Kind Regards Florian

florian.johannssen_1's picture
Joined: Sep 1 2017 - 3:33am
Last seen: 3 years 7 months ago

1 Answer:

Witch database you are using?
I think you need to use database string to date function both side parameter and database filed this is the best option for resolving it,

mca.amitrami's picture
Joined: Jun 11 2018 - 4:58am
Last seen: 5 months 2 hours ago