function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
The NewbieThe Newbie 

Need a validation rule for A<=B<=c for the same object

Hi guys, can somebody help with a validation rule for A<=B<=c for the same object
Sai PraveenSai Praveen (Salesforce Developers) 
Hi,

Can you provide more details on what excatly the A<=B<=C means . Are those filelds on the object and need to check this condition and fire validation if this satisfied?

Thanks,
 
The NewbieThe Newbie
@ Sai Praveen - Yes, those fields are on the same object, so if any of the three fields is null then case shouldn't be closed, an also have also the fileds should be A<=B<=c then the validation rule should get fired.
CharuDuttCharuDutt
Hii Newbie
Try Below Validation 
AND(OR(ISBLANK(A__c),ISBLANK(B__c),ISBLANK(C__c)),OR(A__c <= B__c <= C__c))
Please Mark It As Best Answer If It Helps
Thank You!
The NewbieThe Newbie
@ CharuDutt, Firstly thanks for the reply, but its throwing Error: Incorrect parameter type for operator '<='. Expected Boolean, received Date
CharuDuttCharuDutt
Hii Newbie 
OR(ISBLANK(A__c),ISBLANK(B__c),ISBLANK(C__c))

 
The NewbieThe Newbie
Hi Charu Dutt,
Can you help me with the validation rule for A__c<=B__c<=C__c 
CharuDuttCharuDutt
What Is The Data types Of 
A__c
B__c
C__c 
The NewbieThe Newbie
Date datatype
CharuDuttCharuDutt
Hii Newbie 
AND(A__c  <=  B__c, B__c  <=  C__c)
Please Close Your Query By Mark It As Best Answer If It Helps
Thank You!
The NewbieThe Newbie
Hi Charu Dutt,

The last validation rule dosent work as it supposed to do