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?
Log in to comment and vote
Comments6
Amr from Lunch Flow
Feb 25, 2025
Hey @Dave ,
The fix should now be live, if you clear the existing transactions from the sheet, and press ‘Sync Now’ from the destinations page, they should come through again with the correct dates, mind giving that a try? 😀
Dave Stewart
Feb 25, 2025
Hey Amr,
Thanks so much for making that happen!
I had this sinking feeling that I’d found a really useful product with a fundamental flaw; it’s completely gratifying that you’re on the case to respond to feature requests like this.
Also, not sure how to do this, but may as well mark this one as [solved] ✅
🙏
Amr from Lunch Flow
Feb 25, 2025
Hey Dave,
Thanks for flagging this! I was using a Google Sheets formula for formatting the dates, but you’re right, this should be improved.
Will have a fix out in a few minutes.
Dave Stewart
Feb 25, 2025
Even stranger, the time information is null:
T00:00:00.000Z
why not just export the date then?
2025-02-22