You need to sign in to do that
Don't have an account?
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
SOQL is not working can anyone help me.
My Query: [SELECT ID, Name FROM LEAD WHERE CreatedDate != LastModifiedDate ];
Error: Unknown error parsing query
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:
then the following soql will work:
If this help please mark it