Salesforce Connector Question - Date

[Anonymous]

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

;

[ehr]

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.