Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to show the exact value for date fields in excel file #2304

Closed
vidyasagar-m opened this issue May 31, 2021 · 1 comment
Closed

How to show the exact value for date fields in excel file #2304

vidyasagar-m opened this issue May 31, 2021 · 1 comment

Comments

@vidyasagar-m
Copy link

vidyasagar-m commented May 31, 2021

We're getting the below format for a date from the XLSX package. Could anyone please help me to show the exact value for dates.
image.png

Expected Value:
image.png

@vidyasagar-m vidyasagar-m changed the title How to show the exact value for date fields in excel file when ran on server How to show the exact value for date fields in excel file May 31, 2021
@SheetJSDev
Copy link
Contributor

It's very likely you are in Asia/Kolkata.

SheetJS date basis is the same as Excel, January 1 1900. tz database points to a shift in the offset from +05:21:10 to +05:30:00 in the year 1906.

There is a known bug with V8 (the javascript engine that powers node and chrome) involving these nonstandard offsets, reported nodejs/node#33306 and https://bugs.chromium.org/p/v8/issues/detail?id=7863

This has the same root problem as #1565 so closing in favor of that issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants