Date column value changing when syncing data from API to Google Sheets

Summary

When syncing data from API to Google Sheets, the date column value is changing from ‘2024-11-11’ to ‘45607’. This issue is affecting multiple source values. How can this be avoided?


Question

Hello guys i am syncing data from api to google sheets, in the declared schema , the date column is declares as string, while syncing it is changing the value of my source from 2024-11-11 to 45607, what is the reason behind this , like this it is changing values for lot of source values , how can i avoid this , can anyone please reply to this



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["date-column", "api", "google-sheets", "schema", "value-changing"]

2024-11-11 is exactly 45607 days after January 1, 1900. Just change format of cells to date and it should be fine.