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
gotherthanthougotherthanthou 

End__c <= Start__c

In this validation rule, it is ensuring that the end is either on or after the start.  This works fine if the dates are different, but if they are the same it should pass, but it's not doing so.  Any ideas?  I have confirmed that they are both of type date and neither is DateTime.

Best Answer chosen by Admin (Salesforce Developers) 
SporterSporter

Since it's a validation rule if the End Date is less than or equal to the Start Date in the above formula then the rule trigger your error, so remove the = part and test it again.

All Answers

SporterSporter

Since it's a validation rule if the End Date is less than or equal to the Start Date in the above formula then the rule trigger your error, so remove the = part and test it again.

This was selected as the best answer
gotherthanthougotherthanthou

Duh.  I originally had the logic reversed and so I thought I would be good if I just switched it.

 

Thanks.
SporterSporter

It happens, had a much longer validation rule which I wrote as a opposite to what it should have been and only discovered it after I had finished.