Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

Salesforce Data Load

Hi there,

When i want to data load from Sales Force after 01/01/2018, i have this error message.

ERROR at Row:5:Column:7 value of filter criterion for field 'CreatedDate' must be of type dateTime and should not be enclosed in quotes

Here is the my script;

CUSTOM CONNECT TO "Provider=QvSalesforceConnector.exe;mode=BULK;timeout=100;batchSize=500;plainQueriesOnly=true;pkChunking=false;chunkSize=100000;threadCount=2;ProxyAuthentication=0;XUserId=Deleted;XPassword=Deleted;";

SELECT

    Amount__hpr,

    CreatedDate

FROM Opportunity__hd

WHERE CreatedDate > '01/01/2018'

;

0 Replies