1 Reply Latest reply: Jun 14, 2016 2:44 PM by Jim Harter RSS

    Salesforce Connector Question - Date

    Pascal Rassinoux

      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

      ;