Google Connector Transforming Dates

[barnzey50]

So when connecting to Google Sheets and setting the date as European, dd/mm/yyyy, we are finding that any date that is 12 or below it will swap to american format

so 01/02/1998 will become 02/01/1998 even though the above format is set

Any date greater than 12 stays the way we want to

If we download the sheet as CSV and add to jetstream in the same way the dates stay as they should

So issue I think lays somewhere with the connector. Because we have found this we are now no longer using the Google sheet connector so our data can import correctly :)

[paustint]

@barnzey50 - I am having a difficult time trying to reproduce, I am getting the correct results.

1. Do you know if the fields in your google sheet are stored as dates or just as text? (e.x. when you double click to edit are you getting a date picker or a just editing text)
2. When you load into Jetstream, what does the preview of the data look like? (does it show your data as-is or does it show it as YYYY-MM-DD)

Could you try preparing a sample spreadsheet where you have this issue and sharing it with [email protected] to see if I can reproduce the issue?

[barnzey50]

Sure we can create a sample sheet for you and replicate. We successfully replicated it so we can't use the connector anymore and have to just download the csv and upload the file. That works fine and keeps the dates as they are. They do display as dd/mm/yyyy when it previews the data from the connector.

It's an odd find. Though the person who was going through this issue is on holiday till Wednesday so can go through it then if that's ok?

Sent from Outlook for Androidhttps://aka.ms/AAb9ysg

---

From: Austin Turner @.> Sent: Monday, July 15, 2024 1:04:44 AM To: jetstreamapp/jetstream @.> Cc: barnzey50 @.>; Mention @.> Subject: Re: [jetstreamapp/jetstream] Google Connector Transforming Dates (Issue #976)

@barnzey50https://github.com/barnzey50 - I am having a difficult time trying to reproduce, I am getting the correct results.

1. Do you know if the fields in your google sheet are stored as dates or just as text? (e.x. when you double click to edit are you getting a date picker or a just editing text)
2. When you load into Jetstream, what does the preview of the data look like? (does it show your data as-is or does it show it as YYYY-MM-DD)

Could you try preparing a sample spreadsheet where you have this issue and sharing it with @.*** to see if I can reproduce the issue?

— Reply to this email directly, view it on GitHubhttps://github.com/jetstreamapp/jetstream/issues/976#issuecomment-2227511261, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACHR7ACNAEV2KW6ALEWCJHTZML7YZAVCNFSM6AAAAABKU323MOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMRXGUYTCMRWGE. You are receiving this because you were mentioned.Message ID: @.***>