I simply try to evaluate 2 custom date Fields in a SOQL Query and get Errors:
where date1__c < date2__c
It does not work, is there any trick ?
답변 2개
Hi @Remo Estermann We cannot use the field on the right-hand side of the condition. You can create a formula field(check box) that will compare fields and return a value.
https://help.salesforce.com/s/articleView?id=000386076&type=1