This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Encountering a DateTime problem while displaying a date using Jexcel

 
Minotee Joshi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:




The date is being displayed using DateTime


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
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to Other Open Source Projects.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic