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.

Sign up for GitHub

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

Jump to bottom

false date conversion #33

Open
myruldeen opened this issue Oct 8, 2019 · 8 comments
Open

false date conversion #33

myruldeen opened this issue Oct 8, 2019 · 8 comments

Comments

@myruldeen
Copy link

No description provided.

@DiegoZoracKy
Copy link
Owner

more info, please?

@myruldeen
Copy link
Author

Date from excel sheet with format eg. 1/1/2019
after convert it become 2018-12-31T15:59:14.000Z

@myruldeen
Copy link
Author

then check for the {cellDates: true} according to xlsx/sheetjs documentation

@DiegoZoracKy
Copy link
Owner

There is an open issue on SheetJS regarding that case:
SheetJS/sheetjs#1470

@myruldeen
Copy link
Author

Any updates regarding the date issue?
Another suggestion is using moment(date).add(1, 'days').toDate()

@lalote
Copy link

lalote commented Apr 7, 2020

in my case i have 2020-04-02 19:00:00 and get 2020-04-01T18:59:59.999Z

@myruldeen
Copy link
Author

myruldeen commented Apr 8, 2020 •
edited
Loading

it seems the xlsx library have a problem dealing with date on excel. I just hardcoded it in my own project by making some wrapper :(

@myruldeen
Copy link
Author

fixDate.txt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@DiegoZoracKy @myruldeen @lalote