+ Start a Discussion
KimberlyJKimberlyJ 

Validation formula requiring date based on picklist value

I need a validation formula requiring entry in a date field based on "Yes" value in picklist.
 
Thanks.
JakesterJakester
Code:
and(
    ispickval(yourpicklist__c,"Yes")
   ,isnull(yourdatefield)
)

 

KimberlyJKimberlyJ
You are fabulous!  Thank you so very much!
JakesterJakester
Glad to hear it worked! :smileyvery-happy:
Collaborative eCollaborative e
Is there a way to hide the date field until "Yes" is selected in the picklist?
JakesterJakester

Not without a major coding effort. The good news/bad news with Salesforce is that you can do a lot of stuff without coding, but as soon as you need to get into coding, it becomes a major effort. That's because you need to write an entire VisualForce page that would replicate everything that the current page does, plus the extra bit about hiding a date field.