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

Timezone not taken into account for Date fields #11

Open
mathewTH opened this issue Jun 10, 2020 · 0 comments
Open

Timezone not taken into account for Date fields #11

mathewTH opened this issue Jun 10, 2020 · 0 comments

Comments

@mathewTH
Copy link

I believe this is bubbling up from node-sheets however I thought it was worth raising here for awareness.
Based on ExcelDateToJSDate() https://github.com/urbancups/node-sheets/blob/e927a1692ac7a3798e62e6c2c066f7a620ccb0ad/src/sheets.js#L266-L269
It seems that when date fields are read from a sheet, the TimeZone is assumed to be UTC. It seems to me that the timeZone spreadsheet property should be used to determine the the correct timezone.
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
1 participant
@mathewTH