Encountering a DateTime problem while displaying a date using Jexcel

[Minotee Joshi]

Hello,
I am encountering a problem while displaying dates in Excel using the JExcel API. I have a customized format that displays date from an xml file.
The snippet for this is:

 DateFormat customDateFormat = new DateFormat ("dd MMM yyyy hh:mm:ss");
		WritableCellFormat dateFormat = new WritableCellFormat (customDateFormat);
 

The date is being displayed using DateTime

Date date2 = report.getBackupReport().getLastSuccessfulSystemCartridgeBackup();
		if(date2!=null){
		DateTime date1 = new DateTime(13,row,date2,dateFormat);
	    sheet.addCell(date1);
		}
 

When an excel file displays this date, it is an hour greater than or less than the expected value. For eg. if the xml file shows the date as
<lastSuccessfulSystemCartridgeBackup>2009-07-16T20:54:38-04:00</lastSuccessfulSystemCartridgeBackup>

In my excel file, I get this date as
7/16/2009 6:54:38 PM
instead of
7/16/2009 8:54:38 PM

Please let me know what more do I need to do? Is it a timezone correction? Any ideas, suggestions would be welcome.


Thanks and Regards,
Minotee Joshi
Support Engineer
Prostor Systems, Boulder, CO

[Rob Spoor]

Moving to Other Open Source Projects.