iReport: Broken date import from xls

Hi all,

I have some xls document with date and time in format dd.MM.yyyy (30.05.2012  3:41:51). Looking at iReport output of corresponding TextField I see '151.05.2012 03:41:51'. So, iReport has calculated 'day of the year' for given date (151 for 30.05) and substituted it instead of plain day. And I think that this calculation is done on datasource query stage, because I see it in query previews. The field has type java.lang.String.

How can I tell iReport to handle date as it is in the datasource without any modifications?

 

Yurii

 

monakov.y's picture
Joined: Nov 13 2013 - 1:43am
Last seen: 8 years 4 weeks ago

0 Answers:

No answers yet
Feedback
randomness