ExcelViewer Uploader - Incorrect Date displayed for 01 Mar 2019

Hi,

https://snippet.webix.com/cefaf52f

When I use the above example and upload an excel sheet with a Date value “1-Mar-2019”, the excelviewer displays the value as “02/28/2019”.

Test in (UTC-05:00) Eastern Time (US & Canada) timezone.

Please advise.

Update:

Observed that the date change occurs for all the dates before 10Mar.
The values are already changed in the $init of the data scheme.

Is there any additional handling to parse dates with Daylight Saving in ExcelViewer?

Can someone please advise on this?

The below is the excel data uploaded. Notice the first column goes back by 1 day.

ReportDate Description
1-Mar-19 Test template
2-Mar-19 Test template
10-Mar-19 Test template
11-Mar-19 Test template
12-Mar-19 Test template

@Nastja @Listopad @maksim

Hello @pnam

I can confirm the issue for the mentioned timezone, thank you for reporting.

In your example, it seems that the dates corrupted at the moment when the timezone switches from the Eastern Standard Time to the Eastern Daylight Time (this year it’s March, 10th).

However, I must admit that we rely on the modified version of SheetJS for data export, so we need a bit of time to find out the origins of the issue and if it can be fixed at all from our side.

Thanks for the confirmation @Listopad

Please keep this thread posted on the fix version