Summary
The user is experiencing an issue where date values are being converted from string format to numeric format during the data sync from an API to Google Sheets. The specific example provided shows a date ‘2024-11-11’ being transformed into ‘45607’.
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.