How is timezone for date/time handled when importing into Salesforce

  • 71Views
  • Last Post 14 May 2020
  • Topic Is Solved
Brian Nolan posted this 11 May 2020

When importing data into salesforce I'm seeing the datetime data appears to be handled as if it was GMT.  In the scenario where I saw it this is the setup.

Using a service account to load into Salesforce with the Timezone set to America/El_Salvador in Salesforce.  

The datetime field value in its original form is set to '2016-03-13 16:44:59.000'

After importing the data, viewing the value in Salesforce it is displayed to the user as '2016-03-13 10:44:59.000'  

My question is, for the date time value to be correct do we need to either designate the timezone for the value or add/subtract the correct number of hours and minutes so the value is now GMT?  Is there a way in Skyvia to set what timezone the data is configured as for the import so we don't need to perform this conversion?  In DataLoader you can set the Timezone and it will respect this value when importing the data so that no conversions are needed.

Order By: Standard | Newest | Votes
Dmitriy Muzurov posted this 12 May 2020

Hello Brian,

Thank you for submitting a ticket with us.

Since Skyvia is working with Salesforce through their API, all data it migrated in UTC according to API.

You can configure an expression mapping and use DATEADD function to correct a timezone.

Please check these links: 1 , 2

We are looking forward to hearing from you, should you have any questions.

Brian Nolan posted this 12 May 2020

Ok so the data is received as UTC, will your system pass along the offset time if we include it in the date/time value?  Looks like from the documentation they will accept that format and store the value so it can be converted between GMT and the timezone.

Dmitriy Muzurov posted this 14 May 2020

Dear Brian,

Thank you for getting back to us.

Skyvia passes offset according to Salesforce documentation.

Should you have any questions, do not hesitate to contact us back.