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.
Encountering a DateTime problem while displaying a date using Jexcel
posted 6 years ago
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
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,
Prostor Systems, Boulder, CO