Converting 19 March 2007 to 1070319

[jongr]

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 ?

[Teodor Danciu]

Hi,

 

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.

Teodor