Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

prassinoux
New Contributor

Salesforce Connector Question - Date

I'm tyrin got use the salesforce connector in Qlik Senes to pull data out of a few salesfoce tables using the Bulk API.

Everything is working fine, but I'm trying to add a "where" to the select statement to limit the data set by a date.  I seem to be messing up the syntax, so the load is erroring.

Does anyone know the right way to specify the statement with a date so it will work?

Example:

LOAD Id as [Case_c],

  IsDeleted as [IsDeleted_Case],

  CaseNumber,

  ...

    CreatedDate as [CreatedDate_Case],

    ClosedDate as [ClosedDate_Case];

SELECT Id,

  IsDeleted,

  CaseNumber,

  ...

    CreatedDate,

    ClosedDate

FROM Case

WHERE CreatedDate > 2016-01-01 00:00:00

;

Tags (1)
1 Reply
ehr
New Contributor

Re: Salesforce Connector Question - Date

This format has worked for me:

Let SF_Date =TimeStamp($(Last_Modified_Date),'YYYY-MM-DD')&'T00:00:01Z';

In your case WHERE CreatedDate > 2016-01-01T00:00:00Z  should work.

Community Browser