https://community.qlik.com/t5/Talend-Studio/How-to-delta-load-according-to-Salesforce-s-LastModifiedDate/m-p/2236397#M25119 By definition, LastModifiedDate for existing records is always less than the current date as it cannot be set in the future. <BR />If you know the Datetime to use as a criteria, you must have it as a global or context variable to be used in the tSalesforceInput component for the Query condition. <BR />If you want to get records modified during the last day (or week, or month, ...), use a Salesforce date literal line this: "LastModifiedDate &gt;= LAST_N_DAYS:1" Fri, 24 Aug 2018 12:29:18 GMT TRF 2018-08-24T12:29:18Z https://community.qlik.com/t5/Talend-Studio/How-to-delta-load-according-to-Salesforce-s-LastModifiedDate/m-p/2236396#M25118 <P>I've got the input Salesforce and output RDS connection so far. My database has a column for storing LastModifiedDate from Salesforce. But I don't know where to configure a check for running the job only if LastModifiedDate stored in the database is less than the current Date of running the job. I am very new to Talend, could you please answer with screenshots? There are similar questions but I didn't find them comprehensive enough for a newbie.</P> Sat, 16 Nov 2024 07:46:21 GMT https://community.qlik.com/t5/Talend-Studio/How-to-delta-load-according-to-Salesforce-s-LastModifiedDate/m-p/2236396#M25118 Anonymous 2024-11-16T07:46:21Z https://community.qlik.com/t5/Talend-Studio/How-to-delta-load-according-to-Salesforce-s-LastModifiedDate/m-p/2236397#M25119 By definition, LastModifiedDate for existing records is always less than the current date as it cannot be set in the future. <BR />If you know the Datetime to use as a criteria, you must have it as a global or context variable to be used in the tSalesforceInput component for the Query condition. <BR />If you want to get records modified during the last day (or week, or month, ...), use a Salesforce date literal line this: "LastModifiedDate &gt;= LAST_N_DAYS:1" Fri, 24 Aug 2018 12:29:18 GMT https://community.qlik.com/t5/Talend-Studio/How-to-delta-load-according-to-Salesforce-s-LastModifiedDate/m-p/2236397#M25119 TRF 2018-08-24T12:29:18Z