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

DateTime field wrong timezone. #40

Open
Mmisiek opened this issue Sep 23, 2022 · 2 comments
Open

DateTime field wrong timezone. #40

Mmisiek opened this issue Sep 23, 2022 · 2 comments

Comments

@Mmisiek
Copy link

Mmisiek commented Sep 23, 2022

Hi,
Thanks for a great plugin! I am loading excel with date/time fields, and I noticed that they are one hour later than they should.
Like the wrong timezone is decoded. How it is possible ? Date value in the cell: 5/5/2021 6:38:00 AM is decoded in futter as:2021-05-05T07:38:00.000

@sestegra
Copy link
Owner

Currently, the package only supports native date/time formats.
If you don't use a custom format for date and time, the package will be able to parse them.

As a workaround, select cells with date and format as a date instead of a custom.

See https://github.com/sestegra/spreadsheet_decoder#features-not-yet-supported

@sestegra
Copy link
Owner

Duplicate #37

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

No branches or pull requests

2 participants