-
-
Notifications
You must be signed in to change notification settings - Fork 18
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Google Connector Transforming Dates #976
Labels
bug
Something isn't working
Comments
@barnzey50 - I am having a difficult time trying to reproduce, I am getting the correct results.
Could you try preparing a sample spreadsheet where you have this issue and sharing it with |
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 Android<https://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)
@barnzey50<https://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 GitHub<#976 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ACHR7ACNAEV2KW6ALEWCJHTZML7YZAVCNFSM6AAAAABKU323MOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMRXGUYTCMRWGE>.
You are receiving this because you were mentioned.Message ID: ***@***.***>
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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 :)
The text was updated successfully, but these errors were encountered: