Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Prem ChauhanPrem Chauhan 

CreatedDate != LastModifiedDate In SOQL ?? Urgent.

Object: Lead/Account 
SOQL is not working can anyone help me. 
My Query: [SELECT ID, Name FROM LEAD WHERE CreatedDate != LastModifiedDate ];

Error:  Unknown error parsing query
Best Answer chosen by Prem Chauhan
Ahmed Ansari 13Ahmed Ansari 13

Hi Prem 

Salesforce does not allow direct field to field comparison in SOQL query. Workaround for this is mentioned here (http://https://help.salesforce.com/articleView?id=000187460&type=1)
In your case, add new formula checkbox field called CreatedDateNotEqualToLastModified__c

on Lead:
 

CreatedDate != LastModifiedDate

then the following soql will work:

[Select Id, Name from Lead where CreatedDateNotEqualToLastModified__c =true]
 

If this help please mark it