1
vote
Account Validation rule causing SQL error
SOQL doesn't support the comparison of 2 fields in the where clause - see the fieldExpression section of the WHERE documentation. (And yes the error handling of this invalid case is poor.)
You will ...
1
vote
validation rule formula on picklist field value which have symbols(-,())
The issue might be with the quotation marks around your picklist value.
Try using single quotes instead of double quotes for the picklist value.
AND(
ISBLANK(Closed_Date__c),
ISPICKVAL(...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
validation-rule × 1156validation × 287
formula × 147
apex × 137
trigger × 67
picklist × 59
opportunity × 50
regular-expressions × 50
visual-workflow × 30
formula-field × 29
visualforce × 25
process-builder × 23
workflow × 18
custom-field × 18
case × 17
administration × 17
account × 16
record-type × 16
lead-conversion × 15
multi-select × 15
error-messages × 14
configuration × 13
community × 12
error × 11
approval-process × 11