SELECT count() FROM Case where lastmodifieddate > Createddate
basically i am trying to compare the two date time fields, but i am getting below error in workbench.
MALFORMED_QUERY: Case where lastmodifieddate > Createddate
^ ERROR
at Row:1:Column:51 Bind variables only allowed in Apex code
Best Answer
The way you are trying to do this isn't possible. Salesforce docs:
In your specific scenario, you will want to create a formula field of type Checkbox like:
Then rewrite your query with your WHERE clause like: