Connecting to Salesforce - Convert times to local time

streetyhk — Mon, 22 May 2023 10:22:05 GMT

Hello,

I have a bulk api connection to Salesforce and my data is loading as I expected aside from the date/time values which are being converted to what I think is EST time. I (and all my users) are based in Hong Kng time and the records in Salesforce are in Hong King time.

I have looked around for solutions and they seem to indicate that I should select in the bulk.api settings the 'Convert UTC to local time'

However, when I look at my Bulk api settings, there is no checkbox to select this. I only have 3 options:
Convert SQL dates
Boolean as strings
PK chunking

Appreciate any guidance on where I can find this setting.
Thank you

Re: Connecting to Salesforce - Convert times to local time

Jason_Dyer — Mon, 05 Jun 2023 21:33:27 GMT

Hi Streethyk,

I'm not sure whey you don't see the "Convert UTC to local time" setting in your bulk API connection, but I have reached out to a Qlik internal team for clarification on that point. My understanding is that Salesforce stores dates/times in the database using UTC but can be represented on the end user interface using the user's local time zone.

In the mean time, can you use the convertolocaltime function in the Qlik load script? https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/converttolocaltime.htm

This function will convert the date/time value to your end users' local time in the same way that the "Convert UTC to local time" setting would generally work.

topic Re: Connecting to Salesforce - Convert times to local time in Integration, Extension & APIs

Connecting to Salesforce - Convert times to local time

Re: Connecting to Salesforce - Convert times to local time