search

jetstreamapp / jetstream

A better way to work on Salesforce
https://getjetstream.app/
Other
77 stars 18 forks source link

Google Connector Transforming Dates #976

Open barnzey50 opened 1 month ago

barnzey50 commented 1 month ago

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 commented 1 month ago

@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 support@getjetstream.app to see if I can reproduce the issue?

barnzey50 commented 1 month ago

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: @.***>