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 help with validation rule for A__c<=B__c<=C__c for the same object with date datatype

Hello Everyone,
I'm having trouble with the below validation
Need help with validation rule for A__c<=B__c<=C__c for the same object with date datatype

I have tried this validation rule
AND(A__c<=B__c,B__c<=C__c), but it does work as intended, it does throw an error message even if B__c is greater than A__c, so help me out, I would really appericate any help
VinayVinay (Salesforce Developers) 
This condition A__c<=B__c will fire when B is greater than A,  if you do not want to fire change the condition as per you requirement.

Thanks,
The NewbieThe Newbie
@Vinay, So can you help me how to set the logic for date datatype to acheive this conditon  (A__c<=B__c,B__c<=C__c) in validation rule
VinayVinay (Salesforce Developers) 
Do you want to change validation rule and not to fire when B is greater than A?  If yes use A__c => B__c in validation rule.  Let me know if it works.

Thanks,