I am unable to use a Datetime field in a SOQL query:
SELECT Status FROM Campaign WHERE LastModifiedDate >= Last_Sync__c;
I have a workaround where I create a checkbox formula field which is true when LastModifiedDate > Last_Sync__c
and use that in the SOQL WHERE clause.
Is any other workaround without creating an extra field?