Get your CodeRanch badge!*
The moose likes Other Open Source Projects and the fly likes Encountering a DateTime problem while displaying a date using Jexcel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Encountering a DateTime problem while displaying a date using Jexcel " Watch "Encountering a DateTime problem while displaying a date using Jexcel " New topic
Author

Encountering a DateTime problem while displaying a date using Jexcel

Minotee Joshi
Greenhorn

Joined: Jul 20, 2009
Posts: 1
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

Joined: Oct 27, 2005
Posts: 19543
    
  16

Moving to Other Open Source Projects.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Encountering a DateTime problem while displaying a date using Jexcel
 
Similar Threads
date format problem
public boolean equals (Object obj)
Time format in Java
How to get past date ?
date comparison using javascript