Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT Word v1.0
  HXTT XML v3.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Excel
Differences in date results when using non-English excel file
Jorn Hertsig
2012-10-18 07:28:45.0
I have two excel sheets. They are exactly equal, except one is created in an English Excel 2003, and the other is created in a Dutch Excel 2003. When I query the dates in these excel sheets, the dates queried from the Dutch one are always 1 day after the expected date. The times are correct. I was thinking this might be a timezone thing, but since the difference is a full day, that's unlikely.
I have a unit test demonstrating this behaviour, let me know if you want me to send it over.
I'm using the Excel driver version 4.1.034.
Re:Differences in date results when using non-English excel file
HXTT Support
2012-10-19 17:09:09.0
MS Excel has a stored base time, and maybe that's the issue. Please email us your xls sample.
Re:Re:Differences in date results when using non-English excel file
HXTT Support
2012-10-22 06:38:54.0
Thanks. A fixed version will be released after 2 hours.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap