Sync the date column in a format Sheets can understand

It seems dates are exported as ISO-8601, i.e. “2025-02-22T00:00:00.000Z”.

Google Sheets doesn’t understand this; it seems we have to re-convert:

https://stackoverflow.com/questions/30492832/iso-8601-string-to-date-in-google-sheets-cell

Am I missing something, or is this intentional?

Surely this should be configurable?

Please authenticate to join the conversation.

Upvoters
Status

Completed

Board

💡 Feature Request

Date

About 1 year ago

Author

Dave

Subscribe to post

Get notified by email when there are changes.