Wrong Date - export json to sheet

[silverio]

Hi,

I am getting the wrong date when exporting json -> sheet. Any Ideas why this is happening?
The date in the object is Tue Sep 01 2020 00:00:00 GMT-0500 (Colombia Standard Time).
But when I export it to excel, I get 8/31/2020 11:59:44 PM.

const test = [{
date: new Date(2020,8,1)
}]

var ws = XLSX.utils.json_to_sheet(test);
var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "issue1052");
XLSX.writeFile(wb, "test.xlsx"); ``

[SheetJSDev]

Thanks for sharing!

tz database has the following info for America/Bogota, the IANA time zone for COT:

# Zone	NAME		STDOFF	RULES	FORMAT	[UNTIL]
Zone	America/Bogota	-4:56:16 -	LMT	1884 Mar 13
			-4:56:16 -	BMT	1914 Nov 23 # Bogotá Mean Time
			-5:00	CO	-05/-04

The 16 second difference you are seeing is possibly explained by https://bugs.chromium.org/p/v8/issues/detail?id=7863 -- Chrome is not properly honoring the seconds of the timezone offset in the same way as your system.

[SheetJSDev]

Issue is not fixed, but we're trying to combine similar issues. Closing in favor of #1565