Converting 19 March 2007 to 1070319

The database that I wish to report on uses dates (Long integers) in reverse order with the base in the year 1900.
i.e. The 19 March 2007 is held as 1070319
How can I input the date using the datatype calendar and convert it for use in the report query ?
jongr's picture
Joined: Dec 17 2006 - 11:13pm
Last seen: 12 years 11 months ago

1 Answer:


I think you could define a variable that would parse the value of the numeric report field into a java.util.Date that you then could format and display how you like in your report.
For details about parsing dates and numbers, you should consult the JDK documentation, especially the SimpleDateFormat class.

I hope this helps.
teodord's picture
Joined: Jun 30 2006 - 9:00am
Last seen: 1 day 2 hours ago