Problem by using dates as parameter in my Jasper Server

Posted on November 12, 2018 at 9:16am
0

Hi Jasper fans,

on my jasperserver, i have a report with two date (java.util.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

JasperReports® Server
Jaspersoft Java REST Client
florian.johannssen_1's picture
florian.johannssen_1
5
Joined: Sep 1 2017 - 3:33am
Last seen: 2 years 7 months ago

1 Answer:

0
Posted on November 16, 2018 at 5:59am

Hi 
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
mca.amitrami
11
Joined: Jun 11 2018 - 4:58am
Last seen: 7 months 2 weeks ago
Feedback
randomness