• jayant1.3968382527727017E12
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
I have a batch Data Loader process that I want to create that should extract Event records from Salesforce based on the last run date of the process.  I have read through the Data Loader documentation and see that you can use @process.lastRunDate@ in the SQL Configuration, but how would I do something similar using SOQL?

When I attempt to use something like 'SELECT Id, Subject, ... FROM Event WHERE CreatedDate > @process.lastRunDate@' in the sfdc.extractionSOQL property, it throws a MalformedQueryFault error at the @ symbol.

Any recommendations on how I can write a SOQL statement for the batch process so that only records created after the last run date are retrieved?