topic Convert SALESFORCE Timestamp into UTC in QlikView https://community.qlik.com/t5/QlikView/Convert-SALESFORCE-Timestamp-into-UTC/m-p/32526#M5501 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am extracting data from a SALESFORCE&nbsp; table, Account. I need to covert values of TIMESTAMP field of this table into UTC.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am using&nbsp; condition like <STRONG>FROM Account where CreatedDate &gt;= 2016-06-06T00:00:00Z</STRONG> But missing 10 records from the date of 6th june 2016, because those records were created before 5 AM and the data is taking from 5:30 AM of 6th June 2016.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any idea would be highly appreciated.</P></BODY></HTML> Thu, 01 Mar 2018 07:32:12 GMT bobbyn4u 2018-03-01T07:32:12Z Convert SALESFORCE Timestamp into UTC https://community.qlik.com/t5/QlikView/Convert-SALESFORCE-Timestamp-into-UTC/m-p/32526#M5501 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am extracting data from a SALESFORCE&nbsp; table, Account. I need to covert values of TIMESTAMP field of this table into UTC.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am using&nbsp; condition like <STRONG>FROM Account where CreatedDate &gt;= 2016-06-06T00:00:00Z</STRONG> But missing 10 records from the date of 6th june 2016, because those records were created before 5 AM and the data is taking from 5:30 AM of 6th June 2016.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any idea would be highly appreciated.</P></BODY></HTML> Thu, 01 Mar 2018 07:32:12 GMT https://community.qlik.com/t5/QlikView/Convert-SALESFORCE-Timestamp-into-UTC/m-p/32526#M5501 bobbyn4u 2018-03-01T07:32:12Z