4 Replies Latest reply: Feb 14, 2018 2:25 AM by ChangYuen Teo RSS

    Qlik Salesforce connector timestamp error

    Kundan Ghosh

      I am pulling in data from Salesforce Veeva CRM using native connector in Qlik Sense and I am getting problem with timestamp.

       

      Salesforce saves the value as 16/10/17 but when I extract it into Qlik Sense, it is saving it as 43023.xxx -> the integer part of this value means 15/10/17. However, in other cases, when the timestamp is not near midnight, Qlik Sense saves the values correctly.

       

      I was able to use the following transformation to fix the dates:

       

      Date(Round(Date_vod__c,1))

       

      But I would like to know why is Qlik not able to correctly extract the timestamps. Does Salesforce has a different logic of storing timestamp or is this a bug in Qlik Salesforce connector