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

leni_harishwara — Mon, 26 Jan 2026 21:26:37 GMT

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

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

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