Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
leni_harishwara
Partner - Contributor III
Partner - Contributor III
‎2021-02-12 03:24 AM

Timestamp field is not returning correct value while using ConvertUTCtolocaltime=1 in SFDC connection string

Hi All,

I am currently connecting to SFDC to get data in Qlikview. Earlier I had an issue with dates that in Qlik I can see the date with 1 day delay compared to Salesforce and it is resolved when I used ConvertUTCtolocaltime=1  in connection string.

But now, I am facing another issue with Timestamp fields. Without this ConvertUTCtolocaltime=1 parameter set, the timestamp field was returning correct value and when I set ConvertUTCtolocaltime=1 then there is a time difference of 1hr.

Please share your ideas/experience.

Regards,

Leni Balakrishnan

231 Views
0 Likes
0 Replies