search

stephen-hardy / xlsx.js

XLSX.js is a JavaScript library for converting the data in base64 XLSX files into JavaScript objects - and back! Please note that this library is licensed under the Microsoft Office Extensible File License - a license NOT approved by the OSI. While this license is based off of the MS-PL, which is OSI-approved, there are significant differences.
http://blog.innovatejs.com/?tag=xlsx-js
Other
575 stars 122 forks source link

subtracting with new Date(1900, 0, 0) will miss one hour for CEST #18

Closed eskimoblood closed 10 years ago

eskimoblood commented 10 years ago

When subtracting the date in the convertDate function both dates are not in the same timezone, which leads in an output that is shift by one hour.

new Date(1900, 0, 0)
Sun Dec 31 1899 00:00:00 GMT+0100 (CET)
new Date()
Wed Sep 04 2013 15:38:37 GMT+0200 (CEST)