Eloqua Bulk API Complex Filter Question

54bbebce-d4da-46c0-9b25-a27abed6f56e

    Hi ,

     

    I am having a bit of an issue with the ELOQUA BULK API.

    This issue is specifically to do with filters.
    I have the below filter a combination of the Date Modified & Date created fields.

     

    "filter":"(('{{Contact.Field(C_DateCreated)}}' >= '2015-07-09' AND '{{Contact.Field(C_DateCreated)}}' < '2015-07-10') OR ('{{Contact.Field(C_DateModified)}}' >= '2015-07-09' AND '{{Contact.Field(C_DateModified)}}' < '2015-07-10'))"

     

    This seems to return some correct results but a lot of incorrect results -

    Below is an example result with the email address removed.

     

        {

          "EmailAddress": ,

          "DateCreated": "2015-07-13 03:21:07",

          "DateModified": "2015-07-15 04:30:18"

        },

     

    As you can see it doesn't satisfy the criteria I am trying to use. (On the 9th July 2015).

     

     

     

    When I use the filter seperately it seems to work perfectly. E.G.

     

    "filter":"('{{Contact.Field(C_DateModified)}}' >= '2015-07-09' AND '{{Contact.Field(C_DateModified)}}' < '2015-07-10')"


    The above returns only results with a DateModifed of the 9th of July 2015.

    Is my filter constructed wrong?

     

    Any help is greatly appreciated.

    Thanks,

    Damien.