AnsweredAssumed Answered

Dates in Jaspersoft when exporting to excel

Question asked by Keri Taylor on Oct 31, 2016
Latest reply on Nov 2, 2016 by Keri Taylor

While using Dates in Ad hoc, the dates come out correctly and sort correctly in excel, no data manipulation is needed.


On the other hand, I can't seem to get the dates to come out correctly in Jaspersoft once we export the data to excel when using a formatted date from a Jaspersoft studio report, the date is not sorting correctly or needs to be formatted again after the data is in excel. 


Using the format within the expression of the report:

DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{START_DATE})


When exporting to excel, we get:


Using Ad Hoc report and then exporting, we get (m/d/yy)


How do i get the same results as Ad Hoc?  i don't believe its the formatting, persay, because I also tried the "ad hoc" format and got the same results after export. 


I have opened a ca case but it's been since Sept 16th and nothing has been solved yet. Anyone have any ideas i can try please? Please note that i have tried different formatting... if anyone is interested, here is the date test jrxml file.


The expected results should be the same behavior as the ad hoc report after exporting to excel.