gatsby-source-google-spreadsheet icon indicating copy to clipboard operation
gatsby-source-google-spreadsheet copied to clipboard

Published 20 hours ago • verified publisher icon sondrele

Timezone not taken into account for Date fields

Open mathewTH opened this issue 4 years ago • 0 comments

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.

mathewTH avatar Jun 10 '20 11:06 mathewTH